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

Mon, 15 Oct 2001 18:29:51 -0400 (EDT)
"Michael Richards" <michael@fastmail.ca>
When will vacuum go away?
"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

Tue, 16 Oct 2001 00:57:13 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: When will vacuum go away? 
> 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...

I'm a bit confused.  Are you implying that the rest of the mirrors are
broken or that ftp2 just has info that hasn't been put out for the rest of
the mirrors yet..  I mirror every 4 hours and get:

# ./rsync-postgres-ftp
receiving file list ... done
wrote 110 bytes  read 19042 bytes  7660.80 bytes/sec
total size is 432138525  speedup is 22563.62

when connecting to hub.org and:

@ERROR: Unknown module 'postgresql-ftp'

when connecting to rsync.postgresql.org.

Did I miss something here?

- Brandon



----------------------------------------------------------------------------
 c: 646-456-5455                                            h: 201-798-4983
 b. palmer,  bpalmer@crimelabs.net           pgp:crimelabs.net/bpalmer.pgp5



Tue, 16 Oct 2001 07:42:07 -0400 (EDT)
bpalmer <bpalmer@crimelabs.net>
Why are ftp mirrors out of sync?
bpalmer <bpalmer@crimelabs.net> writes:
> Did I miss something here?

No, but Marc said yesterday that he and Vince were in process of
changing something about mirror configuration.  You'll have to
ask them if mirror admins need to do anything...

			regards, tom lane

Tue, 16 Oct 2001 10:03:15 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Why are ftp mirrors out of sync? 
On Tue, 16 Oct 2001, Tom Lane wrote:

> bpalmer <bpalmer@crimelabs.net> writes:
> > Did I miss something here?
>
> No, but Marc said yesterday that he and Vince were in process of
> changing something about mirror configuration.  You'll have to
> ask them if mirror admins need to do anything...

They will.  It'll involve filling out a form and changing the virtual
server's name.

Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
         56K Nationwide Dialup from $16.00/mo at Pop4 Networking
        Online Campground Directory    http://www.camping-usa.com
       Online Giftshop Superstore    http://www.cloudninegifts.com
==========================================================================




Tue, 16 Oct 2001 10:07:07 -0400 (EDT)
Vince Vielhaber <vev@michvhf.com>
Re: Why are ftp mirrors out of sync? 

In a few hours, vince and I will be shutting down the rsync mirror on
hub.org ... we've been spending the past couple of weeks re-doing and
re-writing *alot* of the sites ...

for instance, if you mirror www.postgresql.org, it no longer includes the
extensive mailing list archives ... that is a seperate web site/mirror ...
so you can omit that if you want to just deal with stuff like the docs ...

also, all sites are going to be 'advertised' the same as the FreeBSD
project does it:

ftp.us.postgresql.org
ftp2.us.postgresql.org
etc ...

no more individual domains ... the one problem we've been noticing over
the years is that search engines are picking up old mirrors, indexing them
and presenting them to ppl ... by moving to the FreeBSD style, when a
mirror goes offline, we can easily redirect that 'name' to a live IP, so
that ppl don't get pointers to stale, or non-existent sites ...



On Tue, 16 Oct 2001, bpalmer wrote:

> > 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...
>
> I'm a bit confused.  Are you implying that the rest of the mirrors are
> broken or that ftp2 just has info that hasn't been put out for the rest of
> the mirrors yet..  I mirror every 4 hours and get:
>
> # ./rsync-postgres-ftp
> receiving file list ... done
> wrote 110 bytes  read 19042 bytes  7660.80 bytes/sec
> total size is 432138525  speedup is 22563.62
>
> when connecting to hub.org and:
>
> @ERROR: Unknown module 'postgresql-ftp'
>
> when connecting to rsync.postgresql.org.
>
> Did I miss something here?
>
> - Brandon
>
>
>
> ----------------------------------------------------------------------------
>  c: 646-456-5455                                            h: 201-798-4983
>  b. palmer,  bpalmer@crimelabs.net           pgp:crimelabs.net/bpalmer.pgp5
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>


Tue, 16 Oct 2001 20:27:19 -0400 (EDT)
"Marc G. Fournier" <scrappy@hub.org>
Re: Why are ftp mirrors out of sync?
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


Thu, 18 Oct 2001 21:25:19 -0400
Joseph Shraibman <jks@selectacast.net>
Re: When will vacuum go away?
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

Thu, 18 Oct 2001 21:30:56 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: When will vacuum go away? 