| From: | Mark <mark(at)ldssingles(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | vacuum and 24/7 uptime |
| Date: | 2001-07-11 21:39:15 |
| Message-ID: | 01071115391505.14673@mark.ldssingles.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-jdbc |
Is Postgresql ready for 24/7 uptime? Our tests have shown that vacuumdb
requires downtime, and if one does this nightly as suggested, well, one has
downtime, 40+ minutes in our case.
My company wants to replace MS SQL Server with PostgreSQL, but we can't
afford downtime to do database maintenance. Is it possible that we are doing
something wrong?
What are the plans for future versions of pgsql? Will vacuum be optomized or
otherwise enhanced to execute more quickly and/or not lock tables?
Thanks,
Mark
PS
I posted more details to the hackers list.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-07-11 21:55:02 | Re: Re: Debian's PostgreSQL packages |
| Previous Message | Bruce Momjian | 2001-07-11 21:27:15 | Re: Re: [GENERAL] Bug in createlang? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark | 2001-07-11 21:55:46 | Re: vacuum and 24/7 uptime |
| Previous Message | Joseph Shraibman | 2001-07-11 21:19:56 | Re: jdbc and unix signals |