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

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

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

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
==========================================================================

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:

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

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