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

From: Evgeny Gridasov <eugrid(at)fpm(dot)kubsu(dot)ru>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: one-field index vs. multi-field index planner
Date: 2006-03-10 17:28:23
Message-ID: 20060310202823.88495774.eugrid@fpm.kubsu.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Evgeny Gridasov <eugrid(at)fpm(dot)kubsu(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Marc Morin 2006-03-10 17:30:41 Trouble managing planner for timestamptz columns
Previous Message Tom Lane 2006-03-10 17:09:19 Re: one-field index vs. multi-field index planner estimates