I have a Postgresql 8.3 instance with tablespaces totalling on about 74G. This
is fine.
But if I ask Postgresql how big my database is, I get a (unexpected) large
answer: 595 GB.
This seems very strange. Disk I/O tests on the system are in the 'normal'
range, but queries are slower than they u
Hi,
On Wed, 14 Sep 2011 04:03:45 -0700, Rob Audenaerde
wrote:
Is this corruption of the database? Or are there ways to 'fix' this
oddity?
Try VACUUM ANALYSE and repeat the operation.
Thanks,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
ga
On Wed, 2011-09-14 at 04:03 -0700, Rob Audenaerde wrote:
> I have a Postgresql 8.3 instance with tablespaces totalling on about 74G.
> This is fine.
>
> But if I ask Postgresql how big my database is, I get a (unexpected) large
> answer: 595 GB.
>
> This seems very strange. Disk I/O tests on th
>On Wed, 2011-09-14 at 04:03 -0700, Rob Audenaerde wrote:
>> I have a Postgresql 8.3 instance with tablespaces totalling on about 74G.
>> This is fine.
>>
>> But if I ask Postgresql how big my database is, I get a (unexpected) large
>> answer: 595 GB.
>>
>> This seems very strange. Disk I/O tests
Rob Audenaerde writes:
>>> I check te database size like this:
>>> select pg_size_pretty(pg_database_size('database'))
>>> 595 GB
>> You should also check the space held in $PGDATA/base.
> I did. It is only 320 MB.
Bizarre. Try breaking the results down table-by-table to see if you can
find wh
On 09/13/2011 05:31 PM, Tom Lane wrote:
Steve Crawford writes:
waiting for server to start../usr/pgsql-9.1/bin/pg_ctl: symbol
lookup error: /usr/pgsql-9.1/bin/pg_ctl: undefined symbol: PQping
There were problems executing "/usr/pgsql-9.1/bin/pg_ctl" -w -l
"upgrade.log" -D "/var/lib/pgsql/9.
I check te database size like this:
select pg_size_pretty(pg_database_size('database'))
595 GB
>>> You should also check the space held in $PGDATA/base.
>> I did. It is only 320 MB.
>Bizarre. Try breaking the results down table-by-table to see if you can
>find where the discrepan
On 09/14/2011 08:48 AM, Steve Crawford wrote:
On 09/13/2011 05:31 PM, Tom Lane wrote:
Steve Crawford writes:
waiting for server to start../usr/pgsql-9.1/bin/pg_ctl: symbol
lookup error: /usr/pgsql-9.1/bin/pg_ctl: undefined symbol: PQping
There were problems executing "/usr/pgsql-9.1/bin/pg
Rob Audenaerde writes:
> It gets stranger. I try this:
> select
> tablename
> , pg_relation_size(tablename)
> , pg_size_pretty(pg_relation_size(tablename) ) as relsize
> , pg_size_pretty(pg_total_relation_size(tablename) ) as disksize
> , pg_total_relation_size(tablename)
> from pg_tables whe
