Re: [PERFORM] Identifying the nature of blocking I/O

2008-08-25 Thread RW
This matches not exactly the topic but it is sometimes helpfull. If you've enabled I/O accounting and a kernel >= 2.6.20 (needs to be compiled with **CONFIG_TASKSTATS=y CONFIG_TASK_DELAY_ACCT=y CONFIG_TASK_XACCT=y CONFIG_TASK_IO_ACCOUNTING=y ) and sysstat package (>= 7.1.5) installed you can use

Re: [PERFORM] The state of PG replication in 2008/Q2?

2008-08-21 Thread RW
My company finally has the means to install a new database server for replication. I have Googled and found a lot of sparse information out there regarding replication systems for PostgreSQL and a lot of it looks very out-of-date. Can I please get some ideas from those of you that are curre