[PERFORM] PG performance issues related to storage I/O waits

2013-07-31 Thread Tasos Petalas
Hello team, We have serious performance issues with a production EDB 9.2AS installation The issue is mostly related to storage I/O bottlenecks during peak hours and we are looking for tunables on any level that could reduce the I/O spikes on SAN and improve overall DB performance. Our storage ar

Re: [PERFORM] PG performance issues related to storage I/O waits

2013-08-05 Thread Tasos Petalas
On Mon, Aug 5, 2013 at 11:28 PM, Tomas Vondra wrote: > Hi, > > On 5.8.2013 17:55, Tasos Petalas wrote: > > > > Seems most of the I/O is caused by SELECT backend processes (READ), > > whereas (WRITE) requests of wal writer and checkpointer processes do &