Re: new to postgres (and db management) and performance already a problem :-( - Mailing list pgsql-performance

From Tom Lane
Subject Re: new to postgres (and db management) and performance already a problem :-(
Date
Msg-id 18875.1137451410@sss.pgh.pa.us
Whole thread Raw
In response to new to postgres (and db management) and performance already a problem :-(  (Antoine)
List pgsql-performance
Antoine <> writes:
> So... seeing as I didn't really do any investigation as to setting
> default sizes for storage and the like - I am wondering whether our
> performance problems (a programme running 1.5x slower than two weeks
> ago) might not be coming from the db (or rather, my maintaining of it).

That does sound like a lack-of-vacuuming problem.  If the performance
goes back where it was after VACUUM FULL, then you can be pretty sure
of it.  Note that autovacuum is not designed to fix this for you: it
only ever issues regular vacuum not vacuum full.

> I couldn't find an easy way to check for disk accessings.

Watch the output of "vmstat 1" or "iostat 1" for info about that.

            regards, tom lane

pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: new to postgres (and db management) and performance already a problem :-(
Next
From:
Date:
Subject: Re: new to postgres (and db management) and performance already a problem :-(