From: Tom Lane <tgl@sss.pgh.pa.us>
To: A B <gentosaker@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Where do a novice do to make it run faster?
Date: Tue, 29 Apr 2008 10:20:48 -0400
Message-ID: <944.1209478848@sss.pgh.pa.us> (raw)
In-Reply-To: <dbbf25900804290209y7924b5b3m3d3f2d305acdb171@mail.gmail.com>
References: <dbbf25900804280856m41c67d96heaa616d39d6c44e0@mail.gmail.com>
<b41c75520804280919l4548b749r45b68ef870ff7329@mail.gmail.com>
<dbbf25900804290009k55c68998p8509c88823104ade@mail.gmail.com>
<dbbf25900804290209y7924b5b3m3d3f2d305acdb171@mail.gmail.com>
"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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, gentosaker@gmail.com
Subject: Re: Where do a novice do to make it run faster?
In-Reply-To: <944.1209478848@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox