database slowdown

From: Mag Gam <magawake(at)gmail(dot)com>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: database slowdown
Date: 2011-01-16 16:44:48
Message-ID: AANLkTikYVBG=Qf+GU9TR7DTKTJ7icfrqV_JE56KpNGf9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am running Redhat 5.2 Linux with Postgresql 8.4.4;

When my disk space is 90% free the database performance is very good.
However, when it reaches close to 20% free the database performance is
bad. I know its bad because I see a lot of 'D' next to 'postgresql'
process when running top and I see a lot 'WAITING' in the 'ps' tree. I
was wondering if there are any filesystem tweaks I can do to make
postgresql run smoother. I am currently using ext3. Should I consider
using a different file system for my database?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2011-01-16 16:51:45 Re: Record with a field consisting of table rows
Previous Message Jon Smark 2011-01-16 16:40:45 Re: Record with a field consisting of table rows