Minimising disk writes

From: Andy Chambers <andychambers2002(at)yahoo(dot)co(dot)uk>
To: pgsql-novice(at)postgresql(dot)org
Subject: Minimising disk writes
Date: 2006-08-11 11:30:35
Message-ID: 20060811113035.68627.qmail@web26901.mail.ukl.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2006-08-11 12:35:49 Re: libpq and transactions
Previous Message Alex du Plessis 2006-08-11 09:03:09 libpq and transactions