Re: [PERFORM] [8.1.4] Help optimizing query

2006-08-27 Thread George Pavlov
:[EMAIL PROTECTED] On Behalf Of Hayes Sent: Saturday, August 26, 2006 1:12 PM To: pgsql-performance@postgresql.org Subject: [PERFORM] [8.1.4] Help optimizing query Hi all, I need help making the below query go faster. There are about 5 of these being done in one report. Some use joins

[PERFORM] [8.1.4] Help optimizing query

2006-08-26 Thread Hayes
Hi all, I need help making the below query go faster. There are about 5 of these being done in one report. Some use joins instead of subselects but they all go about the same speed. I'm not much of a SQL person so I just threw indices on everything involved but it still takes about at least