Re: SELECT's take a long time compared to other DBMS

Поиск
Список
Период
Сортировка
От Nick Fankhauser
Тема Re: SELECT's take a long time compared to other DBMS
Дата
Msg-id NEBBLAAHGLEEPCGOBHDGOEBKIDAA.nickf@ontko.com
обсуждение исходный текст
Ответ на Re: SELECT's take a long time compared to other DBMS  ("Relaxin" <me@yourhouse.com>)
Ответы Re: SELECT's take a long time compared to other DBMS  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Дерево обсуждения 
> Yes I Analyze also, but there was no need to because it was a fresh brand
> new database.

This apparently wasn't the source of problem since he did an analyze anyway,
but my impression was that a fresh brand new database is exactly the
situation where an analyze is needed- ie: a batch of data has just been
loaded and stats haven't been collected yet.

Am I mistaken?

-Nick

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

Предыдущее
От: Rod Taylor
Дата:
Сообщение: Re: PostgreSQL Reliability when fsync = false on Linux-XFS
Следующее
От: Tom Lane
Дата:
Сообщение: Re: SELECT's take a long time compared to other DBMS