Glacial deletes (fixed), now glacial lo vacuum

From: "P(dot)J(dot) \"Josh\" Rovero" <rovero(at)sonalysts(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Glacial deletes (fixed), now glacial lo vacuum
Date: 2001-09-05 12:27:32
Message-ID: 3B961A34.7080507@sonalysts.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks to all who suggested indexing; I added an index to
the running database, and delete performance immediately
increased by a factor or 10.

The problem now is that when I "vacuum verbose analyze", the
pg_largeobject system table takes *forever* (tens of minutes).
A new postmaster seems to be spawned. The current psql session seems
to disconnect (no more messages), while a "tail -f postmaster.log" shows the
vacuum proceeding to the other tables.

select version();
PostgreSQL 7.1.2 on hppa2.0-hp-hpux10.20, compiled by GCC 2.95.3

--
P. J. "Josh" Rovero Sonalysts, Inc.
Email: rovero(at)sonalysts(dot)com www.sonalysts.com 215 Parkway North
Work: (860)326-3671 or 442-4355 Waterford CT 06385
***********************************************************************

Browse pgsql-general by date

  From Date Subject
Next Message Gunnar Rønning 2001-09-05 12:42:24 Re: PL/java?
Previous Message Peter Haworth 2001-09-05 10:29:06 Re: Perl won't eval PgSQL boolean value