On Mon, Apr 16, 2007 at 03:48:00PM -0500, Sam Fourman Jr. wrote:
> On 4/16/07, Bryan Vyhmeister <[EMAIL PROTECTED]> wrote:
> >On Apr 16, 2007, at 4:43 AM, Craig Skinner wrote:
> >> At an ISP that I worked for, all user config data was held in
> >> postgres.
> >> When fields were changed, new flat files were generated (passwd,
> >> shell.allow, ftpusers, apache, quota, etc, etc). The files were then
> >> scp'd to the various server farms from the postgres box.
> >
> >That is an idea I had not thought of. Thank you for the suggestion.
> >That might be a much better way of working with a database.
> >
> >> Having the mail daemons use SQL for auth was too slow.
> >>
> would using postgreSQL for auth with postfix / Dovecot be slow even if
> you used top of the line hardware say a dual core CPU and 4GB memory
> w/ RAID 0?I am thinking very strongly about moving our Exchange Server
> to postfix / PostgresSQL.
That depends on the load, but it's certainly faster to use something
less heavy than a RDBMS - which is very good and very fast at what it
does, but what it does isn't 'simple key-value lookups'.
On that topic, MySQL might perform better here.
Joachim
--
PotD: x11/xpostit - PostIt (R) messages onto your X11 screen
