[prev in list] [next in list] [prev in thread] [next in thread]
List: pgsql-performance
Subject: Re: [PERFORM] Less rows -> better performance?
From: "Guillaume Smet" <guillaume.smet () gmail ! com>
Date: 2008-07-21 11:32:37
Message-ID: 1d4e0c10807210432v45c6272awb1ea13974747de54 () mail ! gmail ! com
[Download RAW message or body]
On Mon, Jul 21, 2008 at 1:25 PM, Andreas Hartmann <andreas@apache.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?
--
Guillaume
--
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]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic