Large files in main/base

Поиск
Список
Период
Сортировка
От Henry, Frank
Тема Large files in main/base
Дата
Msg-id 642070EA75A1664C93E07528705FD2C404A39988@KARMEX02.barco.com
обсуждение исходный текст
Ответы Re: Large files in main/base  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: Large files in main/base  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Large files in main/base  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-admin
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.

My Questions:
What is it?
How can I reduce it?
How can I prevent it from reaching that size again?

Thanks

Frank


DISCLAIMER:
Unless indicated otherwise, the information contained in this message is privileged and confidential, and is intended
onlyfor the use of the addressee(s) named above and others who have been specifically authorized to receive it. If you
arenot the intended recipient, you are hereby notified that any dissemination, distribution or copying of this message
and/orattachments is strictly prohibited. The company accepts no liability for any damage caused by any virus
transmittedby this email. Furthermore, the company does not warrant a proper and complete transmission of this
information,nor does it accept liability for any delays. If you have received this message in error, please contact the
senderand delete the message. Thank you. 

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Postgresql shared_buffer and SHMMAX configuration
Следующее
От: "Ezhil Sundaram"
Дата:
Сообщение: Postgresql shared_buffer and SHMMAX configuration.