When will vacuum go away?

From: "Michael Richards" <michael(at)fastmail(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: When will vacuum go away?
Date: 2001-10-15 22:29:51
Message-ID: 3BCB635F.00000D.82901@frodo.searchcanada.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

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(at)postgresql(dot)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(at)postgresql(dot)org>; Mon, 15 Oct 2001 10:47:08 -0400 (EDT)
(envelope-from tgl(at)sss(dot)pgh(dot)pa(dot)us)
Received: from sss2.sss.pgh.pa.us (tgl(at)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(at)godal(dot)com>
cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Restricting access to Large objects
In-reply-to: <20011010201859(dot)23555(dot)qmail(at)ns(dot)krot(dot)org>
References: <20011010201859(dot)23555(dot)qmail(at)ns(dot)krot(dot)org>
Comments: In-reply-to "Aasmund Midttun Godal" <aasmund(at)godal(dot)com>
message dated "Wed, 10 Oct 2001 20:18:59 +0000"
Date: Mon, 15 Oct 2001 10:46:18 -0400
Message-ID: <14275(dot)1003157178(at)sss(dot)pgh(dot)pa(dot)us>
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
X-Archive-Number: 200110/194
X-Sequence-Number: 5149

"Aasmund Midttun Godal" <aasmund(at)godal(dot)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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Varela Santoalla 2001-10-15 22:29:56 Old backend/frontend protocol versions
Previous Message mlw 2001-10-15 21:05:05 Re: Pre-forking backend - new idea

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2001-10-15 22:44:06 Re: MEDIAN as custom aggregate?
Previous Message Christopher Sawtell 2001-10-15 19:45:03 Re: to_char()?? Works for me.