Re: Reliability Stability of PgSQL & it's JDBC driver - Mailing list pgsql-general

From Nikhil G. Daddikar
Subject Re: Reliability Stability of PgSQL & it's JDBC driver
Date
Msg-id 004101c064de$2c6aadc0$0400a8c0@darkstar
Whole thread Raw
In response to RE: Reliability Stability of PgSQL & it's JDBC driver  ("Nathan Barnett" <nbarnett@cellularphones.com>)
List 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.



pgsql-general by date:

Previous
From: Laurentiu Drob
Date:
Subject: Re: Postgres failover implementation
Next
From: "Trewern, Ben"
Date:
Subject: RE: info please