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

Поиск
Список
Период
Сортировка
От Tim Uckun
Тема Re: Trying to figure out why these queries are so slow
Дата
Msg-id AANLkTikyU0pkGvUCnWbke9Gf8yBGvB+tzEf1TVAtD059@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Trying to figure out why these queries are so slow  (Thom Brown <thom@linux.com>)
Ответы Re: Trying to figure out why these queries are so slow  (Thom Brown <thom@linux.com>)
Список pgsql-general
On Tue, Oct 5, 2010 at 11:38 PM, Thom Brown <thom@linux.com> wrote:
> 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.
>


I did run vacuum analzye on the table I created. The other table I
presume is auto vacuumed since that is on.

I can get you the plan but I don't think it would help because the
result table is now blank.

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

Предыдущее
От: Thom Brown
Дата:
Сообщение: Re: Trying to figure out why these queries are so slow
Следующее
От: Thom Brown
Дата:
Сообщение: Re: Trying to figure out why these queries are so slow