Re: Is v7.1 stable enough?
Christopher Sawtell <csawtell@xtra.co.nz>
From: Christopher Sawtell <csawtell@xtra.co.nz>
To: pgsql-general@postgresql.org
Date: 2001-03-14T06:31:38Z
Lists: pgsql-general
> Not so long ago the feasibility of using PostgreSQL for archiving mail > and news articles was discussed (briefly). I am planning to put the > database to work for just that purpose on a web-based e-mail site > (switching from MySQL whose table locking on INSERT becomes a > performance bottleneck). To work around the 8 KB page limit, I would > have to use the 7.1 beta version, though, or store messages in files and > reference those files from the database. The latter solution does not > really appeal to me, as it makes ensuring referential integrity a pain. > My question is: how stable is the current 7.1 code? Can it be used in a > production environment > or is it meant for internal bug squashing only? Am I asking for > problems? I do not think so, because I have been playing with it and have found that 7.1 works fine. The new features are a real boon and blessing. Admittedly I have only been using it to develop a relatively simple web application for which the database is only tiny biggest table is only ~300 tuples - I am not using any esoteric features either, just selects, inserts, updates and a couple of plsql functions all called from php. Also it is all single user at the moment ( there is only one of me ) and the query rate is very low. Updated using cvsup a couple or three days ago. I'd go for it if I was in your position. -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN 45863470 EMAIL csawtell @ xtra . co . nz CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz -->> Please refrain from using HTML or WORD attachments in e-mails to me <<--