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

Re: dead tuples

From: "Oren Mazor" <oren(dot)mazor(at)gmail(dot)com>
To: "Tim Goodaire" <tgoodaire(at)linux(dot)ca>, pgsql-novice(at)postgresql(dot)org
Subject: Re: dead tuples
Date: 2005-07-22 17:53:22
Message-ID: op.subta8k9v14azh@pbook.local (view raw or flat)
Thread:
Lists: pgsql-novice
Thats exactly what I did. the catch is that I have a perpetual connection  
to the database. that's a problem.

oh well. I've fixed it already, i was just wondering if there was any way  
to circumvent...

in answer to the other question, switching to another dbase is not an  
option at this point in the dev process (more than a handful of years  
investment).

thanks for the prompt answers guys :)

oren

On Fri, 22 Jul 2005 13:43:48 -0400, Tim Goodaire <tgoodaire(at)linux(dot)ca>  
wrote:

> On Fri, Jul 22, 2005 at 01:31:50PM -0400, Oren Mazor wrote:
<snip>
>
> No. There isn't a way to circumvent this. Just set up a cron job to
> regularly vacuum your database and you won't have to worry about your
> database getting big due to dead tuples.
>
> Tim
>
<snip>
>



-- 
Oren Mazor // Developer, Sysadmin, Explorer
GPG Key: http://www.grepthemonkey.org/secure
"Ut sementem feceris, ita metes"

In response to

pgsql-novice by date

Next:From: Pedro TarrafetaDate: 2005-07-22 18:12:16
Subject: Create a row-wise conditional view
Previous:From: Tim GoodaireDate: 2005-07-22 17:43:48
Subject: Re: dead tuples

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