Skip site navigation (1) Skip section navigation (2)

Re: Is there a reason _not_ to vacuum continuously?

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Is there a reason _not_ to vacuum continuously?
Date: 2003-09-18 14:47:03
Message-ID: 20030918224644.Q33706-100000@houston.familyhealth.com.au (view raw or flat)
Thread:
Lists: pgsql-performance
(I've sent him reindexdb off-list)

Chris

On Thu, 18 Sep 2003, Oliver Scheit wrote:

> >> > It's part of postgresql 7.3.  Just get it from the 7.3
> >> > contrib dir - it works fine with 7.2
> >> That's nice to hear. Thanx for that info.
>
> > That's alright - cron job it for once a month - that's what
> > I do.  Basically the problem is that in certain cases
> > (monotonically increasing serial indexes) for instance,
> > PosgreSQL < 7.4 is unable to fully reclaim all the
> > space after a page split.  This means that your indexes
> > just gradually grow really large.
>
> Uhm, I'm unable to find reindexdb. I have postgres 7.3.4
> on another server, but there's no reindexdb. Can you point
> me to the right direction?
>
> Here's what's installed on that machine:
> # rpm -qa|grep postgres
> postgresql-perl-7.2.3-5.73
> postgresql-libs-7.3.4-2PGDG
> postgresql-pl-7.3.4-2PGDG
> postgresql-7.3.4-2PGDG
> postgresql-contrib-7.3.4-2PGDG
> postgresql-server-7.3.4-2PGDG
>
> > Yeah - 7.4 beta3 will be out very shortly, you'll probably
> > have to wait a month or so for a final 7.4 release.
>
> Old version is rockstable and quite fast, so no problem with
> that.
>
> > Even then, ugprading postgresql is always a pain in the neck.
>
> Upgrading to 7.3.4 was quite easy here. dumped the dbs,
> uninstalled 7.2, installed 7.3 and let it read the dump. done.
>
> regards,
> Oli
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html
>


In response to

pgsql-performance by date

Next:From: LN CisnerosDate: 2003-09-18 14:59:54
Subject: Re: rewrite in to exists?
Previous:From: Rhaoni Chiu PereiraDate: 2003-09-18 14:45:09
Subject: Re: [PERFORM] How to force an Index ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group