Re: embedded pgsql media-failure

From: Kokas Zsolt <kokas(dot)zsolt(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: embedded pgsql media-failure
Date: 2009-02-03 14:36:15
Message-ID: ce82ada0902030636l78a4cfcfh9c4d342bf08d20d4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> partitions. The OS should be able to deal with disk issues much more
> robustly than PG. If you were more or less worried about things I

As I see it now, it will be really the Soft-RAID what will suit for
everybody here (including me) as well.

> I'm not sure if you're trying to solve the wrong problem though, flash
> file systems should be used to dealing with this sort of issue and
> would be in a position to provide much more useful mechanisms than just
> duplicating everything. I've got (second-hand) recommendations of
> YAFFS, and have heard good things about JFFS2 as well.

What I see from them is that they supported wear-leveling before
wear-leveling was included into the drives. Currently I have a 16G
SLC-based Swissbit CF-card. Practically the only high-tech part.
Personally I have no practice with any flash file systems, so I would
stick to ext3. Well, I wouldn't say I would have much more expertise
with ext3 and soft-RAID.

> Also, it sounds as though PG may be overkill for this sort of scenario,
> it tends to be pretty write heavy which is something you probably don't
> want to be doing too much of on a flash device. Have you looked at
> anything simpler, maybe sqllite?

Well, I've worked a bit with Oracle before, so PG is quite handy for
me right now. Practically this decision was made before my arrival, I
was basically asked, if I can learn PG too. I'm learning...
PG - and database - was the decision because the flat files were
managed over 15 years, sometimes partly rewritten, revisited and my
real job is to adjust some in the application code as well for the
configuration part of the DB. Guanistical software development :)

Kokas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message James Dooley 2009-02-03 15:12:32 Text search, ERROR: invalid byte sequence for encoding "UTF8": 0xe9640a
Previous Message Igor Katson 2009-02-03 14:30:25 Re: dict-xsyn converts word to synlist, what about backwards?