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

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

[GENERAL] Postgresql partitioning - single hot table or distributed

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

[GENERAL] Help interpreting pg_stat_bgwriter output

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