[Pgpool-general] pgpool-II dies when running a 'vacuum analyze'

[Yoshiyuki Asaba]

Hi,

From: "Bruno Lustosa" <bruno.lists at gmail.com>
Subject: [Pgpool-general] pgpool-II dies when running a 'vacuum analyze'
Date: Wed, 18 Jun 2008 13:39:40 -0300

> I'm running pgpool-II as a load balancer with 2 backends.
> Recently, I deleted a huge table from the database (around 36 million
> rows), and tried to run a vacuum analyze after that to reclaim the 15
> or so gigabytes it occupied.
> The vacuum runs for some time, and then the pooler just dies. On the
> client, I get the message about 'backend closing connection
> unexpectedly'.

Do you use VACUUM VERBOSE?

Regards,
--
Yoshiyuki Asaba
y-asaba at sraoss.co.jp