| From: | Edmund Dengler <edmundd(at)eSentire(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Soft Updates/FFS and Postgresql |
| Date: | 2003-02-07 21:41:47 |
| Message-ID: | Pine.BSO.4.44.0302071635560.30036-100000@cyclops4.esentire.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi all!
Tried searching the web for the answer to this, no real luck. I was
wondering what the current filesystem people would recommend for
Postgresql on an OpenBSD box? I assume it would be FFS, but would the
community agree or disagree on the use of Soft Updates as well? My
belief is that the Soft Updates option is not a good choice due to
the possibility of corrupting the database on a crash. However, I cannot
find a discussion of this with respect to databases one way or the other.
As a side issue, what is the consensus regarding the best open-source
operating system to use for a strictly database server running Postgresql?
Are Linux/FreeBSD/OpenBSD/etc all reasonably close to one another, or
are there configurations that really fly when dealing with large
databases with lots of inserts/selects?
Regards!
Ed
| From | Date | Subject | |
|---|---|---|---|
| Next Message | wsheldah | 2003-02-07 22:10:20 | Re: selects with large offset really slow |
| Previous Message | scott.marlowe | 2003-02-07 21:09:49 | Re: corruption bug in 7.2.3-RH |