Re: one-field index vs. multi-field index planner

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Tom,

ofcourse I've analyzed it.
visible is true for about 0.3% of all rows.
testing table contains about 300,000-500,000 rows.

On Fri, 10 Mar 2006 12:09:19 -0500
Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

> Evgeny Gridasov <eugrid@xxxxxxxxxxxx> 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?

-- 
Evgeny Gridasov
Software Engineer 
I-Free, Russia


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux