| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Andy Chambers <andychambers2002(at)yahoo(dot)co(dot)uk> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Minimising disk writes |
| Date: | 2006-08-11 12:41:16 |
| Message-ID: | 7504.1155300076@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Andy Chambers <andychambers2002(at)yahoo(dot)co(dot)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 :-(
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2006-08-11 12:51:55 | Re: libpq Describe Extension [WAS: Bytea and perl] |
| Previous Message | Tom Lane | 2006-08-11 12:35:49 | Re: libpq and transactions |