Re: Performance suggestions for an update-mostly database? - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Performance suggestions for an update-mostly database?
Date
Msg-id 200410041202.03548.josh@agliodbs.com
Whole thread Raw
In response to Re: Performance suggestions for an update-mostly database?  (Steve Atkins <steve@blighty.com>)
List pgsql-performance
Steve,

> In some ways something like Berkeley DB might be a better match to the
> frontend, but I'm comfortable with PostgreSQL and prefer to have the
> power of SQL commandline for when I need it.

Well, if data corruption is not a concern, you can always turn off
checkpointing.   This will save you a fair amount of overhead.

You could also look at telegraphCQ.   It's not prodcucton yet, but their idea
of "streams" as data sources really seems to fit with what you're talking
about.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: Steve Atkins
Date:
Subject: Re: Performance suggestions for an update-mostly database?
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Caching of Queries