Search Postgresql Archives

Re: Vacuum time degrading

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

 



Well, the good news is that the 2.24.29 kernel solved the kswapd problem.
That bad news is that it didn't help the vacuum time.  In fact, the vacuum
time is now over 6 hours instead of 5 hours.  Whether that is a direct
result of the 2.24.29 kernel, or a coincidence, I don't know at this time.

I guess the next step is to try reindexing a couple of the big indexes and
see if that helps.

Wes



---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

[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