Jean-Michel Pouré<j...@poure.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
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
