[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Postgres slow after a couple of days
From:       Bill Moran <wmoran () potentialtech ! com>
Date:       2004-02-29 21:04:22
Message-ID: 404253D6.2090308 () potentialtech ! com
[Download RAW message or body]

Edwin Pauli wrote:
> 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.

How often do you run VACUUM?

> 
> 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?
> 
> 


-- 
Bill Moran
Potential Technologies
http://www.potentialtech.com


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
[prev in list] [next in list] [prev in thread] [next in thread]