Re: Less rows -> better performance?

Guillaume Smet wrote:
> On Mon, Jul 21, 2008 at 1:25 PM, Andreas Hartmann <andreas(at)apache(dot)org> wrote:
>> SELECT pg_database.datname,
>> pg_size_pretty(pg_database_size(pg_database.datname)) AS size
>> FROM pg_database where pg_database.datname = 'vvz_live_1';
>>
>> datname | size
>> ---------------+---------
>> vvz_live_1 | 2565 MB
>>
>> I wonder why the actual size is so much bigger than the data-only dump - is
>> this because of index data etc.?
>
> More probably because the database is totally bloated. Do you run
> VACUUM regularly or did you set up autovacuum?

You might also want to REINDEX and see if that improves things. My
understanding is that if vacuum isn't run regularly, the indexes may end
up a bit of a mess as well as the tables.

--
Craig Ringer