tweaks for write-intensive dbs ?

From: Jonathan Vanasco <postgres(at)2xlp(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: tweaks for write-intensive dbs ?
Date: 2007-03-28 07:10:08
Message-ID: DE258899-4281-4C7A-B138-158C9E98E7A5@2xlp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

can anyone offer some suggestions on tweaking a system for write-
intensive operations?

my new box is running great for reads / selects , and with 60
connections on tests.

however i'm in the middle of a schema migration / audit, and its
taking ungodly slow.

selecting + analyzing 10,000 records with thousands of queries is no
issue -- its only taking ~ 3 seconds.

but the updating of the records as having been audited ( a bool
flag ) takes 5-10 minutes per set.

the read and write operations are pulling up the data via the
relevant indexes according to analyze.

i've tried turning fsync off, but no luck there.

if anyone could suggest some improvement tips, i'd be grateful. the
system isn't huge (only ~5M records ) , but its taking a rather long
enough time that any extra speed i can come up with would be a huge
improvement..

// Jonathan Vanasco

| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - -
| FindMeOn.com - The cure for Multiple Web Personality Disorder
| Web Identity Management and 3D Social Networking
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - -
| RoadSound.com - Tools For Bands, Stuff For Fans
| Collaborative Online Management And Syndication Tools
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - -

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2007-03-28 07:44:45 Re: tweaks for write-intensive dbs ?
Previous Message filippo 2007-03-28 06:43:38 load the whole database into RAM