Thread: vacuum full...
I am running "vacuum full" via a shell script for a list of large databases now... and I may run out of my scheduled system down time....
If I don't finish all databases and kill the script in the middle... am I going to cause any table corruptions since "vacuum full" is rebuilding the tables and indexes....
thanks,
Jessica
If I don't finish all databases and kill the script in the middle... am I going to cause any table corruptions since "vacuum full" is rebuilding the tables and indexes....
thanks,
Jessica
On Thu, Feb 19, 2009 at 9:35 AM, Jessica Richard <rjessil@yahoo.com> wrote: > I am running "vacuum full" via a shell script for a list of large databases > now... and I may run out of my scheduled system down time.... > > If I don't finish all databases and kill the script in the middle... am I > going to cause any table corruptions since "vacuum full" is rebuilding the > tables and indexes.... No. But may I ask why you are running vacuum full? Is it a regular thing. Do all your tables in all your dbs actually need it?
I used to run vacuum full in one of my bases, but now i'm not running anymore vacuum full, just vacuum analyze in the past 1 month, but the number of necessary pages is increasing every day, now it's in 311264... there is any problem this get increasing?
When I runned Reindex few days ago, this number get not decreased.
I now that vacuum full reorders the relation, but it's the only thing that it does?
Thnks,
Rafael Domiciano
When I runned Reindex few days ago, this number get not decreased.
I now that vacuum full reorders the relation, but it's the only thing that it does?
Thnks,
Rafael Domiciano
On Thu, Feb 19, 2009 at 1:37 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
No. But may I ask why you are running vacuum full? Is it a regularOn Thu, Feb 19, 2009 at 9:35 AM, Jessica Richard <rjessil@yahoo.com> wrote:
> I am running "vacuum full" via a shell script for a list of large databases
> now... and I may run out of my scheduled system down time....
>
> If I don't finish all databases and kill the script in the middle... am I
> going to cause any table corruptions since "vacuum full" is rebuilding the
> tables and indexes....
thing. Do all your tables in all your dbs actually need it?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
On Thu, Feb 19, 2009 at 11:01 AM, Rafael Domiciano <rafael.domiciano@gmail.com> wrote: > I used to run vacuum full in one of my bases, but now i'm not running > anymore vacuum full, just vacuum analyze in the past 1 month, but the number > of necessary pages is increasing every day, now it's in 311264... there is > any problem this get increasing? > When I runned Reindex few days ago, this number get not decreased. > I now that vacuum full reorders the relation, but it's the only thing that > it does? Same question I had for the other poster, why are you not running autovacuum? Has it proven itself not up to the task?
I don't have too much delete and update in the middle of the day to run autovacuum, but in the night, before vacuum analyze, there is some proccess that does delete and update, then run vacuum analyze.
On Thu, Feb 19, 2009 at 5:11 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
On Thu, Feb 19, 2009 at 11:01 AM, Rafael DomicianoSame question I had for the other poster, why are you not running
<rafael.domiciano@gmail.com> wrote:
> I used to run vacuum full in one of my bases, but now i'm not running
> anymore vacuum full, just vacuum analyze in the past 1 month, but the number
> of necessary pages is increasing every day, now it's in 311264... there is
> any problem this get increasing?
> When I runned Reindex few days ago, this number get not decreased.
> I now that vacuum full reorders the relation, but it's the only thing that
> it does?
autovacuum? Has it proven itself not up to the task?