Re: [ADMIN] Speed problem

From: Roger Books <books(at)mail(dot)state(dot)fl(dot)us>
To: pgsql-admin(at)hub(dot)org
Subject: Re: [ADMIN] Speed problem
Date: 1998-11-05 13:30:05
Message-ID: ML-2.2.910272605.9124.books@booksr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


After conferring with Jan Weick I removed the index I had on the
database in question and that seems to have solved my problem.
A corrupt index is a bad thing.

On the memory issue, I'm running PII-300's with 128MB of RAM.
while memory is always full (this machine is also running bind)
and has stuff swapped, there is actually very little swapping
going on. Maybe it's just me but I don't recall ever seeing
a Unix box that didn't have something swapped. Normally those
are procs that are doing nothing. Now, I'm no expert on this
particular program, however, from previous experience...

If you are getting incremental slow downs on a program and
your swap space is not growing at the same rate slow swap
would not be high on my list of suspects.

Roger Books

Browse pgsql-admin by date

  From Date Subject
Next Message Kaj-Michael Lang 1998-11-05 13:48:29 Re: seperate swap drive, was Re: [ADMIN] Speed problem
Previous Message Oleg Bartunov 1998-11-05 13:29:38 Re: seperate swap drive, was Re: [ADMIN] Speed problem