|
Good suggestion. Thanks. What's your take on SSD ? I read somewhere that moving the WAL to SSD helps as well.
> Date: Thu, 20 May 2010 11:36:31 -0600 > Subject: Re: Asynchronous commit | Transaction loss at server crash > From: scott.marlowe@xxxxxxxxx > To: b_ki@xxxxxxxxxxx > CC: pgsql-admin@xxxxxxxxxxxxxx > > On Thu, May 20, 2010 at 10:54 AM, Balkrishna Sharma <b_ki@xxxxxxxxxxx> wrote: > > I need to support several hundreds of concurrent update/inserts from an > > online form with pretty low latency (maybe couple of milliseconds at max). > > Think of a save to database at every 'tab-out' in an online form. > > You can get nearly the same performance by using a RAID controller > with battery backed cache without the same danger of losing > transactions. > > -- > Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin The New Busy is not the too busy. Combine all your e-mail accounts with Hotmail. Get busy. |
