pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedWhen will vacuum go away?
4+ messages / 3 participants
[nested] [flat]
* When will vacuum go away?
@ 2001-10-15 22:29 Michael Richards <michael@fastmail.ca>
2001-10-16 04:57 ` Re: When will vacuum go away? Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Michael Richards @ 2001-10-15 22:29 UTC (permalink / raw)
To: 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@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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: When will vacuum go away?
2001-10-15 22:29 When will vacuum go away? Michael Richards <michael@fastmail.ca>
@ 2001-10-16 04:57 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-10-19 01:25 ` Re: When will vacuum go away? Joseph Shraibman <jks@selectacast.net>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2001-10-16 04:57 UTC (permalink / raw)
To: Michael Richards <michael@fastmail.ca>; +Cc: pgsql-sql
"Michael Richards" <michael@fastmail.ca> writes:
> 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?
VACUUM isn't disappearing any time soon, but 7.2's version of vacuum
runs in parallel with normal transactions, so it's not so painful to
run it frequently. See discussion in development docs,
http://candle.pha.pa.us/main/writings/pgsql/sgml/maintenance.html
> Given trouble with Great Bridge is there any info out there on when
> 7.2 might hit the streets?
The last several postponements of 7.2 beta have *not* been the fault
of the ex-GreatBridge folks around here.
You can find a snapshot that should be pretty durn close to 7.2beta1
at ftp://ftp2.us.postgresql.org/pub/dev/postgresql-snapshot.tar.gz
(note that at last word, other mirrors were not up to date --- if
the doc/TODO file doesn't contain a date in October, it's stale).
I think the only thing we're still waiting on is some datetime fixes
from Tom Lockhart...
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: When will vacuum go away?
2001-10-15 22:29 When will vacuum go away? Michael Richards <michael@fastmail.ca>
2001-10-16 04:57 ` Re: When will vacuum go away? Tom Lane <tgl@sss.pgh.pa.us>
@ 2001-10-19 01:25 ` Joseph Shraibman <jks@selectacast.net>
2001-10-19 01:30 ` Re: When will vacuum go away? Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Joseph Shraibman @ 2001-10-19 01:25 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql
BTW will there be a 7.1.4 release before 7.2 comes out so we can dump our databases to
upgrade to 7.2 w/o there being 60 in the seconds field?
Tom Lane wrote:
> "Michael Richards" <michael@fastmail.ca> writes:
>
>>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?
>>
>
> VACUUM isn't disappearing any time soon, but 7.2's version of vacuum
> runs in parallel with normal transactions, so it's not so painful to
> run it frequently. See discussion in development docs,
> http://candle.pha.pa.us/main/writings/pgsql/sgml/maintenance.html
>
>
>>Given trouble with Great Bridge is there any info out there on when
>>7.2 might hit the streets?
>>
>
> The last several postponements of 7.2 beta have *not* been the fault
> of the ex-GreatBridge folks around here.
>
> You can find a snapshot that should be pretty durn close to 7.2beta1
> at ftp://ftp2.us.postgresql.org/pub/dev/postgresql-snapshot.tar.gz
> (note that at last word, other mirrors were not up to date --- if
> the doc/TODO file doesn't contain a date in October, it's stale).
> I think the only thing we're still waiting on is some datetime fixes
> from Tom Lockhart...
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio. http://www.targabot.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: When will vacuum go away?
2001-10-15 22:29 When will vacuum go away? Michael Richards <michael@fastmail.ca>
2001-10-16 04:57 ` Re: When will vacuum go away? Tom Lane <tgl@sss.pgh.pa.us>
2001-10-19 01:25 ` Re: When will vacuum go away? Joseph Shraibman <jks@selectacast.net>
@ 2001-10-19 01:30 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2001-10-19 01:30 UTC (permalink / raw)
To: Joseph Shraibman <jks@selectacast.net>; +Cc: pgsql-sql
Joseph Shraibman <jks@selectacast.net> writes:
> BTW will there be a 7.1.4 release before 7.2 comes out so we can dump
> our databases to upgrade to 7.2 w/o there being 60 in the seconds
> field?
I doubt it. We're having enough trouble trying to get everyone lined
up to produce a 7.2 beta :-(. Producing another 7.1 patch release
isn't in the cards.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2001-10-19 01:30 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-10-15 22:29 When will vacuum go away? Michael Richards <michael@fastmail.ca>
2001-10-16 04:57 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-10-19 01:25 ` Joseph Shraibman <jks@selectacast.net>
2001-10-19 01:30 ` Tom Lane <tgl@sss.pgh.pa.us>
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