Thread
-
When will vacuum go away?
Michael Richards <michael@fastmail.ca> — 2001-10-15T22:29:51Z
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 -
Re: When will vacuum go away?
Tom Lane <tgl@sss.pgh.pa.us> — 2001-10-16T04:57:13Z
"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
-
Why are ftp mirrors out of sync?
bpalmer <bpalmer@crimelabs.net> — 2001-10-16T11:42:07Z
> 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
-
Re: Why are ftp mirrors out of sync?
Tom Lane <tgl@sss.pgh.pa.us> — 2001-10-16T14:03:15Z
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
-
Re: Why are ftp mirrors out of sync?
Vince Vielhaber <vev@michvhf.com> — 2001-10-16T14:07:07Z
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 ========================================================================== -
Re: Why are ftp mirrors out of sync?
Marc G. Fournier <scrappy@hub.org> — 2001-10-17T00:27:19Z
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) >
-
Re: When will vacuum go away?
Joseph Shraibman <jks@selectacast.net> — 2001-10-19T01:25:19Z
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
-
Re: When will vacuum go away?
Tom Lane <tgl@sss.pgh.pa.us> — 2001-10-19T01:30:56Z
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