Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group