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 18:21:44 |
Message-ID: | BE4B6058.7E5A%wespvp@syntegra.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
On 3/2/05 12:16 PM, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Would you post the complete VACUUM VERBOSE log? The CPU/elapsed time lines
> would help us identify where the time is going.
I'll send it to you directly - its rather long.
>> DETAIL: Allocated FSM size: 1000 relations + 1000000 pages = 5920 kB shared
>> memory.
>
> Well, you don't have a problem with FSM being too small anyway ;-)
Nope... Preparation for when deletes start kicking in down the road. If I
can only do a vacuum once a week, I've got to have lots of space.
Wes
From | Date | Subject | |
---|---|---|---|
Next Message | Wes | 2005-03-02 18:36:01 | Re: Vacuum time degrading |
Previous Message | Tom Lane | 2005-03-02 18:16:10 | Re: Vacuum time degrading |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-03-02 18:21:47 | Re: [pgsql-hackers-win32] snprintf causes regression tests to fail |
Previous Message | Tom Lane | 2005-03-02 18:16:10 | Re: Vacuum time degrading |