Search Postgresql Archives

Re: Vacuum time degrading

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 3/2/05 12:16 PM, "Tom Lane" <tgl@xxxxxxxxxxxxx> 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



---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux