Re: [GENERAL] Question about switchover with PG9 replication

have an updates basebackup at the slave, this is because if you loose a lot of streamed wal files it is impossible for the slave to catch up and have consistent data. -- Cyril SCETBON

[GENERAL] Error when trying to drop a tablespace

relacl | reloptions -+--+-+--+---+-+---+--+---+---+---+-+-+-+--+---+-+--+--+-+++-++--++ (0 rows) 100456 has been found with : /oid2name -s|grep my_tbs Any idea ? -- Cyril SCETBON -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http:

Re: [GENERAL] Error when trying to drop a tablespace

Albe Laurenz wrote: Cyril SCETBON wrote: I get the following error : postgres=# DROP TABLESPACE IF EXISTS my_tbs; ERROR: tablespace "my_tbs" is not empty I've searched in pg_class and I'm not able to find a relation which refers to my_tbs with : You ca

Re: [GENERAL] Error when trying to drop a tablespace

Albe Laurenz wrote: Cyril SCETBON wrote: I get the following error : postgres=# DROP TABLESPACE IF EXISTS my_tbs; ERROR: tablespace "my_tbs" is not empty I've searched in pg_class and I'm not able to find a relation which refers to my_tbs with : postgres=# se

Re: [GENERAL] Error when trying to drop a tablespace

Tom Lane wrote: Cyril SCETBON <[EMAIL PROTECTED]> writes: Tom Lane wrote: So which database has OID 100456? select datname from pg_database where oid = 100456; it's not a database oid but a tablespace oid [ squint... ] There shouldn't be any files

Re: [GENERAL] Error when trying to drop a tablespace

Tom Lane wrote: Cyril SCETBON <[EMAIL PROTECTED]> writes: Albe Laurenz wrote: is there anything in this directory? find . . ./100456 ./100456/100738 ./100456/102333 ./100456/103442 ./100456/102618 ./100456/104159 ./100456/101234 ./100456/102658 ./100456/104477

Re: [GENERAL] Error when trying to drop a tablespace

Albe Laurenz wrote: Cyril SCETBON wrote: I get the following error : postgres=# DROP TABLESPACE IF EXISTS my_tbs; ERROR: tablespace "my_tbs" is not empty I've searched in pg_class and I'm not able to find a relation which refers to my_tbs with : Fi

Re: [GENERAL] Error when trying to drop a tablespace

Albe Laurenz wrote: Cyril SCETBON wrote: I get the following error : postgres=# DROP TABLESPACE IF EXISTS my_tbs; ERROR: tablespace "my_tbs" is not empty I've searched in pg_class and I'm not able to find a relation which r

[GENERAL] redundants indexes can be created

| not null name | character varying(20) | Indexes: "t1_pkey" PRIMARY KEY, btree (id) "idx" btree (id) "idx2" btree (id) "idx3" btree (id) "idx4" btree (id) "idx5" btree (id) Regards -- Cyril SCETBON -- Sent via pgsql-

Re: [GENERAL] redundants indexes can be created

hubert depesz lubaczewski wrote: On Fri, Jul 04, 2008 at 11:54:37AM +0200, Cyril SCETBON wrote: Why postgres does not disallow creating redundants indexes ? Is it the same behaviour in postgresql 8.3 ? Why should it? Redundant indexes are not "bugs". And can be very useful

Re: [GENERAL] redundants indexes can be created

Richard Huxton wrote: Cyril SCETBON wrote: Hi guys, Why postgres does not disallow creating redundants indexes ? Is it the same behaviour in postgresql 8.3 ? Why should it stop you? Do you have an application that randomly generates indexes? I'm just wondering why postgresql/mysql

Re: [GENERAL] redundants indexes can be created

what would characterize a "duplicate" index? Think about partial indexes, where we actually _want_ to have multiple indexes for certain ranges on the same column. this case is not included in duplicate index for me. -- Cyril SCETBON - Ingénieur bases de données AUSY pour France Téléc

[GENERAL] Checkpoints writes

Hi guys, What's the way to count the read/write bytes of the checkpoint process before 8.3 (no pg_stat_bgwriter view :-[ ) I want to distinguish bytes written by checkpoints and others written by the background process thanks -- Cyril SCETBON -- Sent via pgsql-general mailing list (

Re: [GENERAL] Checkpoints writes

Greg Smith wrote: On Thu, 7 Aug 2008, Cyril SCETBON wrote: What's the way to count the read/write bytes of the checkpoint process before 8.3 (no pg_stat_bgwriter view :-[ ) I want to distinguish bytes written by checkpoints and others written by the background process The reason

[GENERAL] kernel version impact on PostgreSQL performance

Does anyone know what can be the differences between linux kernels 2.6.29 and 2.6.30 that can cause this big difference (TPS x 7 !) http://www.phoronix.com/scan.php?page=article&item=linux_2624_2633&num=2 Regards -- Cyril SCETBON -- Sent via pgsql-general mailing list (pgsql

[GENERAL] kernel version impact on PostgreSQL performance

Does anyone know what can be the differences between linux kernels 2.6.29 and 2.6.30 that can cause this big difference (TPS x 7 !) http://www.phoronix.com/scan.php?page=article&item=linux_2624_2633&num=2 Regards -- Cyril SCETBON -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] kernel version impact on PostgreSQL performance

Greg Smith a écrit : Rodger Donaldson wrote: Cyril Scetbon wrote: Does anyone know what can be the differences between linux kernels 2.6.29 and 2.6.30 that can cause this big difference (TPS x 7 !) http://www.phoronix.com/scan.php?page=article&item=linux_2624_2633&num=2