Postgres Pro
Downloads
Home   >   mailing lists

pgsql: Save another little bit of planner overhead on simple queries, by - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Save another little bit of planner overhead on simple queries, by
Date
Msg-id 20071124190851.5CC5A7540F0@cvs.postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
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)

pgsql-committers by date:

Previous
From: momjian@postgresql.org (Bruce Momjian)
Date:
Subject: pgsql: If pg_dump drops a schema, make sure 'search_path' it SET the
Next
From: mkz@pgfoundry.org (User Mkz)
Date:
Subject: pgbouncer - pgbouncer: fix from -stable: if client has params but server