Jean-Michel Pouré<jm(at)poure(dot)com> wrote:
> Some queries range between 400ms and 700ms.
Please post the results of EXPLAIN ANALYZE, not just EXPLAIN.
Also, it helps if you can show the definition of all tables used in
the query (including indexes) and any lines from your postgresql.conf
file which are not at the default value. (And of course, any
overrides to those settings which were in effect on the connection
when the query was run.)
Please repost with that the pgsql-performance list -- this is very
unlikely to be something which will lead to a change to the PostgreSQL
product, which is what this list is about; it's probably just
something you can tune. (Discussion can always come back here if a
problem with PostgreSQL itself is found.)
-Kevin