| 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 |