On Sat, May 29, 2010 at 6:36 PM, Jacob Isaac <ja...@ebrary.com> wrote: > The metrics from my run indicate that I achieve around > for writes - > around 1 row(5k) in 2ms => 500 rows(5K) in 1 sec => 2.5 Mb/sec > > and from your the observation at StumbleUpon > > 200k rows (presuming 100 bytes per row)/sec => 20Mb/sec > Wow !! that an order of difference > I am sure disabling WAL during the writes is giving you a significant boost. >
There is also the compression that J-D has been suggesting. > Are you reading the data at the same time as you are writing? > I don't think so. Is there any locality to the reading you are doing or is it pure random access. St.Ack
