pgsql: Save another little bit of planner overhead on simple queries, by

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Save another little bit of planner overhead on simple queries, by
Date: 2007-11-24 19:08:51
Message-ID: 20071124190851.5CC5A7540F0@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Save another little bit of planner overhead on simple queries, by having
clauselist_selectivity skip some analysis that's useless when there's only
one clause in the given list. Actually this can win even for not-so-simple
queries, because we also apply clauselist_selectivity to sublists such as the
quals matching an index; which are likely to have only a single entry even
when the total query is quite complicated.

Modified Files:
--------------
pgsql/src/backend/optimizer/path:
clausesel.c (r1.87 -> r1.88)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/clausesel.c?r1=1.87&r2=1.88)

Browse pgsql-committers by date

  From Date Subject
Next Message User Mkz 2007-11-24 19:35:22 pgbouncer - pgbouncer: fix from -stable: if client has params but server
Previous Message Bruce Momjian 2007-11-24 17:45:32 pgsql: If pg_dump drops a schema, make sure 'search_path' it SET the