Pavan Deolasee wrote: > Anyways, I don't think there is much > tweaking you can do for such a query except making sure that > your table is not bloated with dead tuples.
To the OP: More explicitly: Make sure you use autovacuum or run VACUUM manually on the table periodically. Would I be correct in suspecting that your real problem is with a more meaningful and complex query, and the one you've posted is oversimplifying what you are trying to do? If that is the case, and you're having problems with queries that do more real work than this one does, maybe you should post EXPLAIN ANALYZE output from such a real world query. -- Craig Ringer -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance