Re: Reliability Stability of PgSQL & it's JDBC driver

From: "Nikhil G(dot) Daddikar" <ngd(at)iname(dot)com>
To: "Nathan Barnett" <nbarnett(at)cellularphones(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Reliability Stability of PgSQL & it's JDBC driver
Date: 2000-12-13 08:20:32
Message-ID: 004101c064de$2c6aadc0$0400a8c0@darkstar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Nathan,

Thanks for your response. It is great to know that Postgres is working out
fine. However, I don't understand what "Vaccum of the DB" means nor what
the "WAL" functionality is. If you could briefly explain these, that would
be great.

Thanks again!
-ngd.

> The main problem that you have in a production system is the VACUUM of the
database.
> This will in most cases severely inhibit performance. If your system
isn't
> 24x7, then you should be fine as you can schedule this for off times. I
> believe that the need to vacuum the database will be removed in the next
> version due to WAL functionality, but I'm sure someone else is better
> qualified to explain that. I just wanted to vouch for the stability of
> Postgres in a production environment.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Trewern, Ben 2000-12-13 11:31:15 RE: info please
Previous Message Laurentiu Drob 2000-12-13 08:13:20 Re: Postgres failover implementation