pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gary Doades <gpd@gpdnet.co.uk>
To: pgsql-performance@postgresql.org
Subject: Re: planner/optimizer question
Date: Thu, 29 Apr 2004 20:23:19 +0100
Message-ID: <40916437.19555.148E3602@localhost> (raw)
In-Reply-To: <1083265934.30065.359.camel@jester>
References: <409153EF.24647.144E9BF7@localhost>

> 
> I guess the real question is, why maintain index flags and not simply
> drop the index entry altogether?
> 
> A more interesting case would be to have the backend process record
> index tuples that it would invalidate (if committed), then on commit
> send that list to a garbage collection process.
> 
> It's still vacuum -- just the reaction time for it would be much
> quicker.
> 
This was my original question.

I guess the problem is with MVCC. The row may have gone from your 
current view of the table but not from someone elses. I don't (yet) 
understand the way it works to say for sure, but I still think it is worth 
pursuing further for someone who does know the deep stuff. They seem 
to have concluded that it is not worth it however.

Cheers,
Gary.






view thread (37+ messages)  latest in thread

Message-ID: <40916437.19555.148E3602@localhost>
Permalink:  ../40916437.19555.148E3602@localhost/
Also on:    postgresql.org/message-id/40916437.19555.148E3602@localhost

 · 

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: pgsql-performance@postgresql.org
  Cc: gpd@gpdnet.co.uk
  Subject: Re: planner/optimizer question
  In-Reply-To: <40916437.19555.148E3602@localhost>

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

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