agora inbox for [email protected]  

help / color / mirror / Atom feed

From: Justin Clift <[email protected]>
To: Tom Lane <[email protected]>
Cc: Zeugswetter Andreas SB SD <[email protected]>
Cc: Vince Vielhaber <[email protected]>
Cc: [email protected]
Subject: Re: sequence indexes
Date: Sat, 26 Jan 2002 19:08:22 +1100
Message-ID: <[email protected]> (raw)
References: <[email protected]>
	<[email protected]>

Tom Lane wrote:
> 
> "Zeugswetter Andreas SB SD" <[email protected]> writes:
> >> I've looked at the problem a little bit --- there's literature more
> >> recent than Lehmann-Yao that talks about how to do btree compaction
> >> without losing concurrency.  But it didn't get done for 7.2.
> 
> > Yes, there must be. Informix handles this case perfectly.
> > (It uses a background btree cleaner)

As an idle thought, I wonder what other maintenance tasks we could have
a process in the background automatically doing when system activity is
low ?

Maintenance
***********
- Index compaction
- Vacuum of various flavours

Tuning
******
- cpu_tuple costings (and similar) recalculation(s)


Can't think of anything else off the top of my head though.

Regards and best wishes,

Justin Clift

> 
> Right, I had hoped to fold it into lazy VACUUM, but ran out of time.
> (Of course, had I known in August that we'd still not have released
> 7.2 by now, I might have kept after it :-()
> 
>                         regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html

-- 
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
   - Indira Gandhi

view thread (16+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: sequence indexes
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox