Received: from mail1.hub.org (webmail.hub.org [216.126.85.1]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9FNZVP71948 for ; Mon, 15 Oct 2001 19:35:31 -0400 (EDT) (envelope-from michael@fastmail.ca) Received: from mail.interchange.ca ([216.126.79.2]) by mail1.hub.org (8.11.3/8.11.4) with ESMTP id f9FMTwX57875 for ; Mon, 15 Oct 2001 18:29:58 -0400 (EDT) (envelope-from michael@fastmail.ca) Received: by mail.interchange.ca (Fastmailer, from userid 555) id 6A4702227; Mon, 15 Oct 2001 18:29:51 -0400 (EDT) MIME-Version: 1.0 Message-Id: <3BCB635F.00000D.82901@frodo.searchcanada.ca> To: pgsql-sql@postgresql.org Subject: When will vacuum go away? From: "Michael Richards" X-Fastmail-IP: 24.43.130.241 Date: Mon, 15 Oct 2001 18:29:51 -0400 (EDT) Content-Transfer-Encoding: 7bit Content-Type: Text/Plain X-Archive-Number: 200110/193 X-Sequence-Number: 5148 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 ; 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" 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" 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 X-Archive-Number: 200110/194 X-Sequence-Number: 5149 "Aasmund Midttun Godal" 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