m. hvostinski wrote:
Thanks to all for the feedback. I keep getting impressed by how
flexible PostgreSQL is.
Any ideas which query should perform better? I put together all the
suggested approaches below.
EXPLAIN ANALYZE of these queries in psql should give hard numbers. My
bet is on approach 3 to be the fastest since it does not require a join
node and has shorter target list / memory to move around.
regards
Yeb Havinga
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
