Postgres Pro
Downloads
Home   >   mailing lists

Re: one-field index vs. multi-field index planner estimates - Mailing list pgsql-performance

From Tom Lane
Subject Re: one-field index vs. multi-field index planner estimates
Date
Msg-id 6628.1142010559@sss.pgh.pa.us
Whole thread Raw
In response to one-field index vs. multi-field index planner estimates  (Evgeny Gridasov <eugrid@fpm.kubsu.ru>)
Responses Re: one-field index vs. multi-field index planner  (Evgeny Gridasov <eugrid@fpm.kubsu.ru>)
List pgsql-performance
Tree view 
Evgeny Gridasov <eugrid@fpm.kubsu.ru> writes:
> Recently I've discovered an interesting thing (Postgres version 8.1.3):

Have you ANALYZEd the table since loading it?  What fraction of the rows
have visible = true?

            regards, tom lane

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Process Time X200
Next
From: Evgeny Gridasov
Date:
Subject: Re: one-field index vs. multi-field index planner