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

List:       pgsql-performance
Subject:    Re: [PERFORM] Where do a novice do to make it run faster?
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2008-04-29 14:20:48
Message-ID: 944.1209478848 () sss ! pgh ! pa ! us
[Download RAW message or body]

"A B" <gentosaker@gmail.com> writes:
> I'm not sure what the size acctually is... But I can't imagine that it
> is 1,6 GB!!! I'd say I have 11MB of data in it...

Sounds like you've got a rather severe case of table and/or index bloat.
This is typically caused by not vacuuming often enough.

The easiest way to get the size back down is probably to dump and reload
the database.  After that you need to look at your vacuuming practices.

> Will I see a general improvement in performance in 8.3.X over 8.1.11?

Probably so, if only because it has autovacuum turned on by default.
That's not really a substitute for careful administration practices,
but it helps.

			regards, tom lane

-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
[prev in list] [next in list] [prev in thread] [next in thread]