pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Michael Richards <michael@fastmail.ca>
To: pgsql-sql@postgresql.org
Subject: When will vacuum go away?
Date: Mon, 15 Oct 2001 18:29:51 -0400 (EDT)
Message-ID: <3BCB635F.00000D.82901@frodo.searchcanada.ca> (raw)

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



view thread (4+ messages)  latest in thread

Message-ID: <3BCB635F.00000D.82901@frodo.searchcanada.ca>
Permalink:  ../3BCB635F.00000D.82901@frodo.searchcanada.ca/
Also on:    postgresql.org/message-id/3BCB635F.00000D.82901@frodo.searchcanada.ca

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: michael@fastmail.ca
  Subject: Re: When will vacuum go away?
  In-Reply-To: <3BCB635F.00000D.82901@frodo.searchcanada.ca>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox