postgres runaway process

From: "Fred J" <fred(at)arkansaswebs(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: postgres runaway process
Date: 2001-06-10 21:06:23
Message-ID: 9g0ngg$7dq$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm building a site based on linux/apache/PHP/Postgresql.
(redhat7,apache 1.3/PHP4.04/Postgres 7.1)
I have the following SQL on a PHP page that processes a rather complex
search form.

SELECT talent.*,models.* FROM talent join models on
(models.usrindx=talent.indx) where validated=1 AND ( (av_runway=true) OR
(av_fashion=true) OR (av_sport=true) OR (av_casual =true) OR (av_print
=true) OR (av_swimwear =true) OR (av_lingerie =true) OR (av_glamour =true)
OR (av_art =true) OR (av_nude =true) OR (av_erotic =true) OR
(av_artisticnude =true) OR (av_acting =true) OR (av_tv =true) OR (av_adult
=true) OR (av_film =true) OR (av_dancer =true) OR (av_stage =true) OR
(av_adv =true) OR (av_livepromo =true)) AND haircolor ='Blond' AND
hairlength ='Waist-length'

I have about 25 records in table talent which has about forty columns
i have 2 records in table models which has maybe 65 columns.

the server will porcess sql without the last two AND clauses (eg without
'AND haircolor ='Blond' AND hairlength ='Waist-length' at the end)

BUT
pgsql generates a runaway process that loads up the server and fills the
log file as fast as the server will fill it on the above sql.

the log file if filled with blank lines?!
over 4 gig of em in just a few minutes.

any ideas?

I expect the sql to grow by at least another 25 AND clauses. Is this sql too
long?
where would I look for docs specifying the length of an SQL statement?

Thank You
Fred

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-06-10 21:33:12 Re: inserting, index and no index - speed
Previous Message zilch 2001-06-10 20:51:00 Re: inserting, index and no index - speed