Re: [PERFORM] [8.1.4] Help optimizing query

2006-08-27 Thread George Pavlov
George > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[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 he

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