Search Postgresql Archives

Vacuum causing crashes

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

 



Hi,

We're running a Postgres 8.0.1 database and have a maintenance process that runs vacuum on selected tables every 10 minutes. Each table takes around 2-3 seconds to vacuum. Since we've started this process we've seen a lot of postmaster crashes (it says it received signal 9). It appears these crashes occur when we try to stop a vacuum by interrupting the vacuumdb process, but sometimes they occur without us having to do this.

Any ideas? We didn't experience so many database crashes before we started vacuuming regularly.

Regards
--
David Mitchell
Software Engineer
Telogis

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
      message can get through to the mailing list cleanly

[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