Postgres slow after a couple of days

From: Edwin Pauli <edwin(at)epauli(dot)dyndns(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgres slow after a couple of days
Date: 2004-02-29 20:42:05
Message-ID: 40424E9D.202@epauli.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris 2004-02-29 20:54:07 Re: Postgres slow after a couple of days
Previous Message Gaetano Mendola 2004-02-29 20:17:09 Re: Are Triggers Synchronous