Re: Default Stats Revisited

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Default Stats Revisited
Дата
Msg-id 200403111458.07934.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: Default Stats Revisited  (Robert Treat <xzilla@users.sourceforge.net>)
Ответы Re: Default Stats Revisited  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: unsafe floats
Следующее
От: Josh Berkus
Дата:
Сообщение: The Name Game: postgresql.net vs. pgfoundry.org