Re: Minimising disk writes

* Tom Lane <tgl@sss.pgh.pa.us> [2006-08-11 08:41:16 -0400]:

> Andy Chambers <andychambers2002@yahoo.co.uk> writes:
> > I'm at the investigation stage of a project that involves putting a
> > database on an embedded device.  One of the problems we face is that
> > the filesystem is on Flash Memory so we need to minimize any writes.
>
> > Is it just a bad idea to use postgresql for this type of thing?
>
> Fraid so ... PG is not designed with the idea of avoiding disk writes,
> indeed it's pretty aggressive at pushing committed data out to disk.
> You could maybe get away with flash storage for a read-mostly, very
> low update rate database, but the software isn't going to help you
> do it :-(

I assumed that one can't really avoid writing to disk when committing
data (do any free databases try to avoid this?).  I was more worried
about temporary tables created in join and sort operations.

Thanks,
Andy



___________________________________________________________
Copy addresses and emails from any email account to Yahoo! Mail - quick, easy and free.
http://uk.docs.yahoo.com/trueswitch2.html