Re: Default Stats Revisited

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Default Stats Revisited
Date: 2004-03-11 22:58:07
Message-ID: 200403111458.07934.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Treat 2004-03-11 23:08:09 Re: pgFoundry
Previous Message Tom Lane 2004-03-11 22:57:45 Re: unsafe floats