| From: | Matthias Howell <Matthias(dot)Howell(at)semeon(dot)com> |
|---|---|
| To: | "mtlpug(at)postgresql(dot)org" <mtlpug(at)postgresql(dot)org> |
| Subject: | vacuum question |
| Date: | 2013-10-29 15:14:12 |
| Message-ID: | D59001D0F7E96C46A119B694B7F2755AB58228@MTL-IT-EXCH02.submtl.voxco.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | mtlpug |
my database stopped on Friday to prevent wrap around. I started a vacuum.
The vacuum is still running. it has been running on one table since Friday night at about 11 pm EDT. We have hit the 84 hour mark and have no idea how much longer it will run.
This is what I think I know:
The reason that I know the time is that the vacuum was waiting for an autovacuum that I killed and the autovacuum has been waiting since then.
The reason that I believe it to still be running is that it is a) not waiting in pg_stat_activity and b) when I run top I can see cpu and memory usage fluctuate for the vacuum process.
This from pgadmin:
The table has Rows (estimated) 1,270,070,000
and is 349 GB with Index size of 454 GB.
Dead tuples 280,968,228
Any ideas if we can estimate how much longer?
any help appreciated.
M
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthias Howell | 2013-10-29 16:36:27 | Re: vacuum question |
| Previous Message | Morgan Tocker | 2011-01-10 21:29:13 | Hello All |