Re: Query using SeqScan instead of IndexScan - Mailing list pgsql-performance

From chris smith
Subject Re: Query using SeqScan instead of IndexScan
Date
Msg-id 3c1395330604011650r61c793a7td3e8be58ab023c7b@mail.gmail.com
Whole thread Raw
In response to Re: Query using SeqScan instead of IndexScan  ("Jim C. Nasby" <jnasby@pervasive.com>)
Responses Re: Query using SeqScan instead of IndexScan  ("chris smith" <dmagick@gmail.com>)
List pgsql-performance
On 4/2/06, Jim C. Nasby <jnasby@pervasive.com> wrote:
> On Sat, Apr 01, 2006 at 11:23:37AM +1000, chris smith wrote:
> > On 4/1/06, Brendan Duddridge <brendan@clickspace.com> wrote:
> > > Hi Jim,
> > >
> > > I'm not quite sure what you mean by the correlation of category_id?
> >
> > It means how many distinct values does it have (at least that's my
> > understanding of it ;) ).
>
> Your understanding is wrong. :) What you're discussing is n_distinct.

Geez, I'm going well this week ;)

Thanks for the detailed info.

--
Postgresql & php tutorials
http://www.designmagick.com/

pgsql-performance by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: [Solved] Slow performance on Windows .NET and OleDb
Next
From: "chris smith"
Date:
Subject: Re: Query using SeqScan instead of IndexScan