Re: Select * is very slow

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Select * is very slow
Дата
Msg-id 4CD7DBEC02000025000373E2@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: Select * is very slow  (Thomas Kellerer <spam_eater@gmx.net>)
Список pgsql-performance
Thomas Kellerer <spam_eater@gmx.net> wrote:
> Kevin Grittner, 08.11.2010 18:01:

>> I would add a request to see the output from `VACUUM VERBOSE
>> employee;`.

> Do you really think that VACCUM is the problem? If the OP only
> selects two columns it is apparently fast.
> If he selects all columns it's slow, so I wouldn't suspect dead
> tuples here.
>
> My bet is that there are some really large text columns in
> there...

That's something we can infer pretty well from the verbose output.

-Kevin

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

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: Select * is very slow
Следующее
От: Scott Carey
Дата:
Сообщение: Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?