Re: [ADMIN] Details about pg_stat_bgwriter

Greg Smith, 09.06.2010 07:14: I probably should have explained the next part. I've now shared what I do with this information at http://www.pgcon.org/2010/schedule/events/218.en.html Basically, if you put the data from the two snapshots into one of the Statistics Spreadsheet versions, you'll get

Re: [ADMIN] Details about pg_stat_bgwriter

Thomas Kellerer wrote: I don't think we have a caching issue though, it's just one (regular) bulk import that does some heavy writes which we need to tune. Read performance is absolutely fine, but everything around vacuum and checkpointing seems to slow down the import massively. So would takin

[ADMIN] Fatal Error during PITR Recovery

Hi, My production is running PostgreSQL v8.2.3 on CentOS release 5.2 (Final). As part of our routine, we just wanted to make sure and practice once in a while, whether PITR recovery process is performed without fail. When I started the recovery process, after sometime, I see the following error

[ADMIN] Only standby Server in Cloud(Amazon), not the primary

Hello, In PostgreSQL 9.x, using Streaming replication (hot standby with PITR), is it possible to have just the standby server in Cloud(Amazon) and the primary database local ?What I am trying to achieve is get the backups guaranteed in cloud, if I just have my standby server there ? Is it techn

Re: [ADMIN] Fatal Error during PITR Recovery

"Gnanakumar" writes: > My production is running PostgreSQL v8.2.3 on CentOS release 5.2 (Final). > As part of our routine, we just wanted to make sure and practice once in a > while, whether PITR recovery process is performed without fail. When I > started the recovery process, after sometime, I

[ADMIN] insert OS command results into a table on a remote system ?

Hi All; I want to gather OS command based stats such as the results of commands like: 'df' 'iostat' 'free' etc and put the results into a temp table that I can then select from. I need to do this all from the db since I wont have OS/shell access, only 'psql -h' access. Is this possible? Ca

Re: [ADMIN] insert OS command results into a table on a remote system ?

Kevin Kempter wrote: > I want to gather OS command based stats such as the results of commands > like: 'df' 'iostat' 'free' etc and put the results into a temp table that I > can then select from. > I need to do this all from the db since I wont have OS/shell access, > only 'psql -h' access. Is

Re: [ADMIN] Filesystem and PG configuration

On Fri, Jun 4, 2010 at 7:53 PM, Anh Ky Huynh wrote: > > A good start: > > Tuning: > http://www.westnet.com/~gsmith/content/postgresql/pgbench-scaling.htm > Benchmark: http://edoceo.com/liber/db-postgresql-benchmark > > Here'