Re: Postgres Databases growing without much reason

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Postgres Databases growing without much reason
Дата
Msg-id 20030214130303.GA20307@svana.org
обсуждение исходный текст
Ответ на Postgres Databases growing without much reason  (Andreas Rust <rust@webnova.de>)
Ответы Re: Postgres Databases growing without much reason
Список pgsql-general
On Fri, Feb 14, 2003 at 11:58:00AM +0100, Andreas Rust wrote:
> I completely dumped the dbase, dropped and restored it and instead of 2 GB
> it was
> only using 150 MB then. Now, after having this running for about 2 Weeks
> constantly,
> the performance is falling down again and the database grew up to 550 MB
> again, although
> there was not much inserted into the dbase-tables.

Can you find which files in the data directory are growing? They're numbered
by oid, which you can lookup in pg_class.

Hope this helps,

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Support bacteria! They're the only culture some people have.

Вложения

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

Предыдущее
От: Pablo Varasa
Дата:
Сообщение: Re: db "hot switch"
Следующее
От: jco@cornelius-olsen.dk
Дата:
Сообщение: Re: How can I parse a Postgresql array result in php?