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
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
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
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