Re: Default Stats Revisited - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Default Stats Revisited
Date
Msg-id 200403111458.07934.josh@agliodbs.com
Whole thread Raw
In response to Re: Default Stats Revisited  (Robert Treat <xzilla@users.sourceforge.net>)
Responses Re: Default Stats Revisited
List pgsql-hackers
Robert,

> Do you plan on handeling primary key columns differently (since they are 
> likely to be unique and indexed) ?

The same as any other indexed column.

> Also how will you handle column that are part of expressional indexes (where 
> foo is true for example) ?

See my original proposal.  These columns will be ignored.  Expressions have 
their own stats.

> Final thought... I'm a DBA and I think the straight number is simpler, 
though 
> could be convinced to go with whichever is higher... 

Thanks.

-- 
-Josh BerkusAglio Database SolutionsSan Francisco



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: unsafe floats
Next
From: Josh Berkus
Date:
Subject: The Name Game: postgresql.net vs. pgfoundry.org