Re: [GENERAL] Postgresql partitioning - single hot table or distributed

2010-06-30 Thread sam mulube
in place actually give you? Thanks for the reply. Sam On 30 June 2010 02:39, Vick Khera vi...@khera.org wrote: On Tue, Jun 29, 2010 at 4:00 PM, sam mulube sam.mul...@gmail.com wrote: Alternatively we wondered about partitioning by the server_id foreign key, using for example the modulo

[GENERAL] Postgresql partitioning - single hot table or distributed

2010-06-29 Thread 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

[GENERAL] Help interpreting pg_stat_bgwriter output

2009-08-11 Thread sam mulube
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