[PERFORM] archive_command too slow.

Hi friends, I am running 2 Linux machines, kernel 3.13.0-45-generic #74-Ubuntu SMP. Postgresql version 9.4 in both machine, in a Hot Standby cenario. Master-Slave using WAL files, not streaming replication. The archive_command from master is: archive_command = '/usr/bin/rsync -a -e "ssh" "%p"

Re: [PERFORM] Very slow checkpoints

Would not be the case slightly decrease the shared buffer, lower your checkpoints_timeout for eg 5 minutes or decrease checkpoints_segments and set the checkpoint_completation_target to 0.5 to not mess up the next checkpoints? What logs tell me is that a checkpoint occurs immediately to the other

Re: [PERFORM] MusicBrainz postgres performance issues

Robert many thanks for feedback!! Could you post your new pgbouncer config file?? How many postgresql process do you have now at OS with this new conf?? How many clients from app server hit your pgbouncer?? Regards, Regards, 2015-03-16 11:32 GMT-03:00 Robert Kaye : > > > On Mar 16, 2015, at

Re: [PERFORM] Indexscan is only used if we use "limit n"

which column does your indice cover? Em Qua, 2007-08-15 às 16:36 -0300, Sebastián Baioni escreveu: > Hello, > Whe are running PostgreSQL 8.2.0 on amd64-portbld-freebsd6.2, compiled > by GCC cc (GCC) 3.4.6 [FreeBSD] 20060305. > The query only uses the index if we have a "limit n": > > Without "Li

[PERFORM] help me problems with pg_clog file

when i try do \d in psql on a table i get this message! this happens too when i try to run pg_dump...   ERROR:  could not access status of transaction 4294967295DETAIL:  could not open file "pg_clog/0FFF": File or directory not found     someone could help me?? PleasE!