When will vacuum go away?
Michael Richards <michael@fastmail.ca>
From: "Michael Richards" <michael@fastmail.ca>
To: pgsql-sql@postgresql.org
Date: 2001-10-15T22:29:51Z
Lists: pgsql-hackers
I've been watching for this for some time. First it was 7.0, then
7.1. Does anyone have any idea on when the row re-use code will be
ready?
Currently I'm running into trouble with an OLTP database. It grows
like crazy, has only 3,000,000 rows and vacuum takes a good 1/2 hour.
Given trouble with Great Bridge is there any info out there on when
7.2 might hit the streets?
-Michael
_________________________________________________________________
http://fastmail.ca/ - Fast Free Web Email for Canadians
>From pgsql-sql-owner@postgresql.org Tue Oct 16 01:07:12 2001
Received: from sss.pgh.pa.us ([192.204.191.242])
by postgresql.org (8.11.3/8.11.4) with ESMTP id f9FEl8r27466
for <pgsql-sql@postgresql.org>; Mon, 15 Oct 2001 10:47:08 -0400 (EDT)
(envelope-from tgl@sss.pgh.pa.us)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id f9FEkIc14278;
Mon, 15 Oct 2001 10:46:18 -0400 (EDT)
To: "Aasmund Midttun Godal" <aasmund@godal.com>
cc: pgsql-sql@postgresql.org
Subject: Re: Restricting access to Large objects
In-reply-to: <20011010201859.23555.qmail@ns.krot.org>
References: <20011010201859.23555.qmail@ns.krot.org>
Comments: In-reply-to "Aasmund Midttun Godal" <aasmund@godal.com>
message dated "Wed, 10 Oct 2001 20:18:59 +0000"
Date: Mon, 15 Oct 2001 10:46:18 -0400
Message-ID: <14275.1003157178@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Archive-Number: 200110/194
X-Sequence-Number: 5149
"Aasmund Midttun Godal" <aasmund@godal.com> writes:
> How can I restrict access to large objects.
You can't. This is one of the many deficiencies of large objects.
regards, tom lane