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

From Evgeny Gridasov
Subject Re: one-field index vs. multi-field index planner
Date
Msg-id 20060310202823.88495774.eugrid@fpm.kubsu.ru
Whole thread Raw
In response to Re: one-field index vs. multi-field index planner estimates  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: one-field index vs. multi-field index planner
List pgsql-performance
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@sss.pgh.pa.us> wrote:

> 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?

--
Evgeny Gridasov
Software Engineer
I-Free, Russia

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: one-field index vs. multi-field index planner estimates
Next
From: "Marc Morin"
Date:
Subject: Trouble managing planner for timestamptz columns