Re: Slow Postgresql server

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Slow Postgresql server
Дата
Msg-id 1176396964.13754.16.camel@state.g2switchworks.com
обсуждение исходный текст
Ответ на Re: Slow Postgresql server  (Guido Neitzer <lists@event-s.net>)
Ответы Re: Slow Postgresql server  (Jeff Frost <jeff@frostconsultingllc.com>)
Список pgsql-performance
On Thu, 2007-04-12 at 10:19, Guido Neitzer wrote:
> On 12.04.2007, at 08:59, Ron wrote:

>
> Depends. As I said - if the whole DB fits into the remaining space,
> and a lot of website backend DBs do, it might just work out. But this
> seems not to be the case - either the site is chewing on seq scans
> all the time which will cause I/O or it is bound by the lack of
> memory and swaps the whole time ... He has to find out.

It could also be something as simple as a very bloated data store.

I'd ask the user what vacuum verbose says at the end

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

Предыдущее
От: Steve
Дата:
Сообщение: Re: Question about memory allocations
Следующее
От: Jeff Frost
Дата:
Сообщение: Re: Slow Postgresql server