Re: Improve performance of query

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Richard Rowell <richard(at)bowmansystems(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Improve performance of query
Date: 2004-12-16 17:02:20
Message-ID: 20041216170220.GK10437@ns.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

* Richard Rowell (richard(at)bowmansystems(dot)com) wrote:
> I have included an EXPLAIN ANALYZE, relevant table counts, and relevant
> indexing information. If anyone has any suggestions on how to improve
> performance.... TIA!

Just a thought- do the UNION's actually have to be union's or would
having them be 'UNION ALL's work?

Stephen

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jon Anderson 2004-12-16 17:08:20 Seqscan rather than Index
Previous Message John A Meinel 2004-12-16 16:59:05 Re: Improve performance of query