Re: Postgresql Success rate

Article View: ahn.tech.linux

Article #3332

#3332

From: rich
Date: Thu, 01 Jul 1999 00:00

20 lines
1647 bytes

: It is my understanding the 6.4 and 6.4.1 are buggy, but 6.4.2 is solid.

: I am currently running 6.4.2

We had database corruption problems with all versions
of 6.4 and 6.5 when we absolutely hammered them from
more than one hundred clients. However, under a moderate
load, they seemed to work OK. Nevertheless the corruption
didn't inspire confidence and now the particular application
in question uses a commercial DB.

The other problem with Postgres is the way it handles
BLOBs as separate files all stored in one directory.
You can't really store more than about 10,000 BLOBs in
your database before the inefficiencies of ext2fs kill
any performance.

Rich.

rich@annexia.org   Play xracer! http://www.annexia.org/freeware/xracer.html

Technical Details

Message-ID: <377b60a0.0@nnrp1.news.uk.psi.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <7ldkt9$26kc$1@nntp01.global.co.za> <377A6AEF.75891528@mohawksoft.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f5392,a1b03957da4370c4
X-Google-Attributes: gidf5392,public
X-Google-Thread: 10c696,a1b03957da4370c4
X-Google-Attributes: gid10c696,public
X-Google-Thread: faa64,a1b03957da4370c4
X-Google-Attributes: gidfaa64,public
X-Google-Thread: 11033e,a1b03957da4370c4
X-Google-Attributes: gid11033e,public
From: rich@no-annexia-spam.org
Subject: Re: Postgresql Success rate
Date: 1999/07/01
Message-ID: <377b60a0.0@nnrp1.news.uk.psi.net>
X-Deja-AN: 495998021
Sender: <rich@callisto.postmaster.co.uk>
References: <7ldkt9$26kc$1@nntp01.global.co.za> <377A6AEF.75891528@mohawksoft.com>
X-Trace: 1 Jul 1999 13:35:44 GMT, callisto.postmaster.co.uk
User-Agent: tin/pre-1.4-981225 ("Volcane") (UNIX) (Linux/2.2.9 (i686))
Newsgroups: ahn.tech.linux,alt.os.linux,comp.os.linux.development.apps,comp.os.linux.development.system

Reply to Parent Message