Minimising disk writes - Mailing list pgsql-novice

From Andy Chambers
Subject Minimising disk writes
Date
Msg-id 20060811113035.68627.qmail@web26901.mail.ukl.yahoo.com
Whole thread Raw
Responses Re: Minimising disk writes  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Hi,

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.

Looking at the docs, it seems that temp_buffers, and
work_mem are
the two variables we might play about with to achieve
this.  Are
there any others I should be aware of?

Is it just a bad idea to use postgresql for this type
of thing?

Regards,
Andy




___________________________________________________________
Try the all-new Yahoo! Mail. "The New Version is radically easier to use" – The Wall Street Journal
http://uk.docs.yahoo.com/nowyoucan.html

pgsql-novice by date:

Previous
From: Alex du Plessis
Date:
Subject: libpq and transactions
Next
From: Tom Lane
Date:
Subject: Re: libpq and transactions