problem with me or postgres ?

Поиск
Список
Период
Сортировка
От Fred J
Тема problem with me or postgres ?
Дата
Msg-id 9g18sv$ae8$1@news.tht.net
обсуждение исходный текст
Ответы Re: problem with me or postgres ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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





В списке pgsql-general по дате отправления:

Предыдущее
От: Vivek Khera
Дата:
Сообщение: Re: inserting, index and no index - speed
Следующее
От: Alex Pilosov
Дата:
Сообщение: Re: Re: inserting, index and no index - speed