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
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 |