30min
checkpoint_segments = 10
checkpoint_completion_target = 0.9
Not sure what other config settings are pertinent here, but I can supply
them if required.
I am using postgresql 8.3.7-0ubuntu8.04.1, running on an OpenVZ VPS.
Thanks for any pointers.
Sam Mulube
Hi,
we are considering database partitioning as a possible solution to
some performance issues we are having with our database, and we are
trying to decide on a partitioning scheme. We have a moderately write
heavy application (approx 50 inserts per second, with writes
outnumbering reads by roughl
esql partitioning in place
actually give you?
Thanks for the reply.
Sam
On 30 June 2010 02:39, Vick Khera wrote:
> On Tue, Jun 29, 2010 at 4:00 PM, sam mulube wrote:
>> Alternatively we wondered about partitioning by the server_id foreign
>> key, using for example the modul
