From: | Bo Lorentsen <bl(at)netgroup(dot)dk> |
---|---|
To: | Vivek Khera <khera(at)kcilink(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Commercial postgresql |
Date: | 2003-09-02 09:49:16 |
Message-ID: | 1062496156.25824.7054.camel@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, 2003-09-02 at 04:08, Vivek Khera wrote:
> I use it in 24/7/365 system which is heavily written to and read
> from. The drawbacks I have are:
How depressing, may I ask that PG version you are using ?
> 1) upgrade to major versions require dump/restore which is a
> significant amount of downtime for a large DB.
Ok, this is not a thing you do very often, and it would help is we got a
"diff" (since last backup) pg_dump. As one could install the new DB in
parallel with produktion, and then just apply the diff dump on the db
swap.
> 2) the need to run vacuum on tables to keep them from bloating too
> much. on my system which is very busy, sometimes running vacuum
> pushes the disk beyond its limits and slows the whole system to a
> crawl.
How often does this vacuum run, and how many delete/updates are there in
between ?
> 3) Index bloat is apparently a bigger problem than I thought.
This does not sound too nice !
> If you want commercial support, it is out there. There are at least
> two companies offering it.
But you have not been unsing any of there services ?
/BL
From | Date | Subject | |
---|---|---|---|
Next Message | Malcolm Warren | 2003-09-02 09:55:21 | Use of oids |
Previous Message | Jason Godden | 2003-09-02 09:34:26 | Re: automatic update |