On Wed, Sep 14, 2011 at 03:56:27AM +0200, Craig Ringer wrote:
You can't change the encoding of a database in-place.
Thanks Craig and all the other that responded.
Enjoy your day.
Regards
Johann
--
Johann SpiesTelefoon: 021-808 4699
Databestuurder / Data
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
Hi,
On Wed, 14 Sep 2011 04:03:45 -0700, Rob Audenaerde
rob.audenae...@valuecare.nl 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
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 the
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 the system
Rob Audenaerde rob.audenae...@valuecare.nl 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
On 09/13/2011 05:31 PM, Tom Lane wrote:
Steve Crawfordscrawf...@pinpointresearch.com 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
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 discrepancy is.
On 09/14/2011 08:48 AM, Steve Crawford wrote:
On 09/13/2011 05:31 PM, Tom Lane wrote:
Steve Crawfordscrawf...@pinpointresearch.com 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
Rob Audenaerde rob.audenae...@valuecare.nl 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)
10 matches
Mail list logo