| From: | Wes <wespvp(at)syntegra(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Postgresql-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Vacuum time degrading |
| Date: | 2005-03-02 15:46:46 |
| Message-ID: | BE4B3C06.7E0C%wespvp@syntegra.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On 2/28/05 6:53 PM, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Again, VACUUM VERBOSE info would be informative (it's sufficient to look
> at your larger tables for this).
It took 5.2 hours again tonight to do the vacuum. I don't see anything out
of the ordinary - no explanation for the non-linear increases in vacuum
time.
This is what shows up at the end:
INFO: free space map: 93 relations, 282 pages stored; 1712 total pages
needed
DETAIL: Allocated FSM size: 1000 relations + 1000000 pages = 5920 kB shared
memory.
The tables all show something like:
INFO: "blah": found 0 removable, 366326534 nonremovable row versions in
3241829 pages
DETAIL: 0 dead row versions cannot be removed yet.
There were 0 unused item pointers.
0 pages are entirely empty.
Wes
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hemapriya | 2005-03-02 16:06:48 | pg_shadow passwd decrypt |
| Previous Message | Frank Finner | 2005-03-02 15:01:55 | PL/Perl trusted throws error on example function |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Wong | 2005-03-02 15:47:40 | Re: 8.0.X and the ARC patent |
| Previous Message | Dave Cramer | 2005-03-02 15:41:57 | Re: 8.0.X and the ARC patent |