Re: Need to tune for Heavy Write

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Adarsh Sharma <adarsh.sharma@xxxxxxxxxx>
Subject: Re: Need to tune for Heavy Write
From: Dusan Misic <promisic@xxxxxxxxx>
Date: Thu, 4 Aug 2011 10:43:25 +0200
Cc: pgsql-performance@xxxxxxxxxxxxxx
In-reply-to: <CAGdZ+NAFPHHn-wk2qv=b-o26FbNhLffmvZpULbJ-3nYggdwYfg@mail.gmail.com>
References: <4E3A268C.9090409@orkash.com> <CAGdZ+NAFPHHn-wk2qv=b-o26FbNhLffmvZpULbJ-3nYggdwYfg@mail.gmail.com>

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" <adarsh.sharma@xxxxxxxxxx> wrote:

References:
- Need to tune for Heavy Write
  - From: Adarsh Sharma

Prev by Date: Re: Need to tune for Heavy Write
Next by Date: Re: Need to tune for Heavy Write
Previous by thread: Re: Need to tune for Heavy Write
Next by thread: Re: Need to tune for Heavy Write
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux