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

2013-07-31 Thread KONDO Mitsumasa
Hi Tasos, (2013/07/31 20:58), Tasos Petalas wrote: We have set synchronous_commit to off but since almost all of application queries are using prepared statements we don't get any real benefit. Also please advise on any postgres.conf modification that could significantly affect storage load

Re: [PERFORM] Fw: [osdldbt-general] Running DBT5 on remote database server

2013-07-31 Thread Greg Smith
On 7/22/13 10:13 PM, amul sul wrote: I want test the PostgreSQL performance using DBT5, where my PostgreSQL running on server (say 192.168.56.101) and want to test the performance executing DBT5 on other machine (say 192.168.56.102). You can do this. Here's the help for the run_workload.sh com

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

2013-07-31 Thread Tomas Vondra
On 31 Červenec 2013, 13:58, Tasos Petalas wrote: > Hello team, > > We have serious performance issues with a production EDB 9.2AS > installation Are you sure you've sent this to the right list? Because this is a community mailing list for PostgreSQL, not for EDB. If you have a support contract wit

[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