Re: [PERFORM] Need to tune for Heavy Write

Scott is right. His answer solves the problem in the long run. Even if your write load increases, it will perform fast enough. For now try increasing checkpoint_segments size, restart Postgres for new settings to take effect and try again with your write load. If you are not satisfied with write

Re: [PERFORM] Need to tune for Heavy Write

To put it simple, you need to set checkpoint_segments way higher than your current value! Link: wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server On Aug 4, 2011 6:57 AM, "Adarsh Sharma" wrote:

Re: [PERFORM] Need to tune for Heavy Write

Hi Adarsh, Have you set checkpoint_segments and checkpoint_completion_target the right way? Tuning these parameters are a MUST if you want good write performance. See this link for more information: http://www.postgresql.org/docs/current/static/runtime-config-wal.html

Re: [PERFORM] Postgres performance on Linux and Windows

Thank you Andy for your answer. That is exactly what I had expected, but it is better to consult with experts on this matter. Again, thank you. Dusan On Aug 3, 2011 7:05 PM, "Andy Colson" wrote: > On 8/3/2011 11:37 AM, Dusan Misic wrote: >> I had done some testing for my ap

[PERFORM] Postgres performance on Linux and Windows

I had done some testing for my application (WIP) and I had executed same SQL script and queries on real physical 64-bit Windows 7 and on virtualized 64-bit CentOS 6. Both database servers are tuned with real having 8 GB RAM and 4 cores, virtualized having 2 GB RAM and 2 virtual cores. Virtualized