Postgres slow after a couple of days

Поиск
Список
Период
Сортировка
От Edwin Pauli
Тема Postgres slow after a couple of days
Дата
Msg-id 40424E9D.202@epauli.dyndns.org
обсуждение исходный текст
Ответы Re: Postgres slow after a couple of days  (Chris <list@1006.org>)
Re: Postgres slow after a couple of days  (Bill Moran <wmoran@potentialtech.com>)
Список pgsql-general
Hi,

A few days ago i've installed PostgreSQL 7.4.1
After the installation, Postgres was very fast.
But now, a few days later, it getting slower and slower.

I've looked in the data-dir and i was confused when i see the big
size from that directory.

A dump (created with pg_dump) is about 1MB.

pauli# cd /usr/local/pgsql/data
epauli# du -h
4.4M    ./base/1
4.4M    ./base/17141
  19M    ./base/17142
4.4M    ./base/17143
4.4M    ./base/17149
4.4M    ./base/17158
4.5M    ./base/29156
4.4M    ./base/29175
4.5M    ./base/29184
  55M    ./base
160K    ./global
  32M    ./pg_xlog
  98K    ./pg_clog
  87M    .


Does anybody know why this directory is 87MB while the database is
1MB?


--
Edwin Pauli

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

Предыдущее
От: Gaetano Mendola
Дата:
Сообщение: Re: Are Triggers Synchronous
Следующее
От: Chris
Дата:
Сообщение: Re: Postgres slow after a couple of days