Re: Showing Column Statistics Number

Поиск
Список
Период
Сортировка
От Michael Fuhr
Тема Re: Showing Column Statistics Number
Дата
Msg-id 20060111222138.GA88301@winnie.fuhr.org
обсуждение исходный текст
Ответ на Showing Column Statistics Number  ("Dave Dutcher" <dave@tridecap.com>)
Список pgsql-performance
On Wed, Jan 11, 2006 at 04:05:18PM -0600, Dave Dutcher wrote:
> I've looked around through the docs, but can't seem to find an answer to
> this.  If I change a column's statistics with "Alter table alter column
> set statistics n", is there a way I can later go back and see what the
> number is for that column?  I want to be able to tell which columns I've
> changed the statistics on, and which ones I haven't.

pg_attribute.attstattarget

http://www.postgresql.org/docs/8.1/interactive/catalog-pg-attribute.html

--
Michael Fuhr

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Dave Dutcher"
Дата:
Сообщение: Showing Column Statistics Number
Следующее
От: Jean-Philippe Côté
Дата:
Сообщение: Extremely irregular query performance