Re: Large files in main/base

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Large files in main/base
Дата
Msg-id AANLkTimwmBRruoPZ51oEoZWgcOYOmS2HhKdZCiBIeA1n@mail.gmail.com
обсуждение исходный текст
Ответ на Large files in main/base  ("Henry, Frank" <frank.henry@barco.com>)
Список pgsql-admin
On Fri, Jul 9, 2010 at 7:31 AM, Henry, Frank <frank.henry@barco.com> wrote:
> Hello everyone,
>
> We had a problem with one of our servers and had noticed that the
> postgres/8.3/main folder had become quite large (>650mb).
> PostgreSQL confirmed this via a query but when I queried the size of the
> tables I was barely reaching 3mb.
>
> After looking around, I found one file with about 580 mb. From the
> contents I have the feeling it is some kind of changelog or similar.

pg_clog?  If that's growing you've got a possible problem with a long
running query.

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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Large files in main/base
Следующее
От: Brad Nicholson
Дата:
Сообщение: Re: High Availability: Hot Standby vs. Warm Standby