| From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Simultaneous vacuum-ing |
| Date: | 2002-10-28 22:35:41 |
| Message-ID: | 20021028173541.N21128@mail.libertyrms.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Oct 28, 2002 at 11:25:53AM -0800, Medi Montaseri wrote:
> Simultaneous as in, running vacuumdb(1) simultaneously or sequentially..
> For example,
>
> vacuumdb -z -d SomeDB &
> vacuumdb -z -d SomeDB &
> psql -c "some SQL statement, where I'm in a 7.2.3 and supposedly, I can
> do vacuum and
> DB transactions at the same time"
This I haven't tested. I would anticipate performance trouble,
though.
A
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Siebert | 2002-10-28 23:00:17 | Is there such a thing as a peer to peer database? |
| Previous Message | Alvaro Herrera | 2002-10-28 22:07:51 | Re: command-line history (readline) fails |