Postgres Pro
Downloads
Home   >   mailing lists

Re: vacuum locks up database - Mailing list pgsql-admin

From Tom Lane
Subject Re: vacuum locks up database
Date
Msg-id 2563.1051909853@sss.pgh.pa.us
Whole thread Raw
In response to vacuum locks up database  (jonesbl@WellsFargo.COM)
List pgsql-admin
Tree view 
jonesbl@WellsFargo.COM writes:
> Is there anyway to force vacuum to run more as a background job and not
> block others from accessing the database during the vacuum process?

Vacuum without the FULL option won't block others.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Daniel Seichter"
Date:
Subject: Re: pg_dumpall / pg_dump
Next
From: Tom Lane
Date:
Subject: Re: pg_dumpall / pg_dump