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

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

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?

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Evgeny Gridasov 2006-03-10 17:28:23 Re: one-field index vs. multi-field index planner
Previous Message Scott Marlowe 2006-03-10 16:46:56 Re: Process Time X200