Postgres Pro
Downloads
Home   >   mailing lists

Re: Improve performance of query - Mailing list pgsql-performance

From Stephen Frost
Subject Re: Improve performance of query
Date
Msg-id 20041216170220.GK10437@ns.snowman.net
Whole thread Raw
In response to Improve performance of query  (Richard Rowell <richard@bowmansystems.com>)
List pgsql-performance
Tree view 
* Richard Rowell (richard@bowmansystems.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
Attachment

pgsql-performance by date:

Previous
From: Richard Rowell
Date:
Subject: Improve performance of query
Next
From: Jon Anderson
Date:
Subject: Seqscan rather than Index