On 2010-06-10 19:50, Anne Rosset wrote:
> Any advice on how to make it run faster?
What timing do you get if you run it with \t (timing on) and without
explain analyze ?
I would be surprised if you can get it much faster than what is is.. I
may be that a
significant portion is "planning cost" so if you run it a lot you might
a prepared statement.
In response to
pgsql-performance by date
|Next:||From: hubert depesz lubaczewski||Date: 2010-06-10 18:33:56|
|Subject: Re: Need to increase performance of a query|
|Previous:||From: Lacey Powers||Date: 2010-06-10 18:01:30|
|Subject: Re: Large (almost 50%!) performance drop after upgrading