Re: Trying to figure out why these queries are so slow

Поиск
Список
Период
Сортировка
От Thom Brown
Тема Re: Trying to figure out why these queries are so slow
Дата
Msg-id AANLkTikLVKUu9p7g7hk8vVsSP-c4Pchowc=nPZ53-=4z@mail.gmail.com
обсуждение исходный текст
Ответ на Trying to figure out why these queries are so slow  (Tim Uckun <timuckun@gmail.com>)
Ответы Re: Trying to figure out why these queries are so slow  (Tim Uckun <timuckun@gmail.com>)
Список pgsql-general
On 5 October 2010 10:20, Tim Uckun <timuckun@gmail.com> wrote:
> The database machine is a linode host.

Good choice ;)

Obvious question, but I'll ask it: Have you run ANALYZE or VACUUM
ANALZYE on the database?  Also being able to see the query plan would
help.

--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

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

Предыдущее
От: Rajesh Kumar Mallah
Дата:
Сообщение: Re: streaming replication question
Следующее
От: Tim Uckun
Дата:
Сообщение: Re: Trying to figure out why these queries are so slow