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

--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to