Re: very slow simple query - outer join makes it quicker

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: very slow simple query - outer join makes it quicker
Дата
Msg-id 1082376074.24414.3.camel@jester
обсуждение исходный текст
Ответ на very slow simple query - outer join makes it quicker  ("Gerard Isdell" <gerard.isdell@kinetic.co.uk>)
Список pgsql-performance
Дерево обсуждения 
> There are other tables, such as the messages table, that have 10s of
> thousands of rows and they return records much more quickly.

> There must be something seriously wrong for simple queries like this to take
> so long.

Have you run VACUUM recently?

If not, run VACUUM FULL against the users table and see if that makes a
difference.

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

Предыдущее
От: "Gerard Isdell"
Дата:
Сообщение: very slow simple query - outer join makes it quicker
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: Horribly slow hash join