Re: Need to increase performance of a query - Mailing list pgsql-performance

From Jesper Krogh
Subject Re: Need to increase performance of a query
Date
Msg-id 4C112B19.6080908@krogh.cc
Whole thread Raw
In response to Need to increase performance of a query  (Anne Rosset <arosset@collab.net>)
Responses Re: Need to increase performance of a query  (Anne Rosset <arosset@collab.net>)
List pgsql-performance
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
benefit from
a prepared statement.


--
Jesper

pgsql-performance by date:

Previous
From: Anne Rosset
Date:
Subject: Need to increase performance of a query
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Need to increase performance of a query