Re: SKIP LOCKED DATA

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thomas Munro <munro(at)ip9(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: SKIP LOCKED DATA
Date: 2012-01-16 05:33:29
Message-ID: 2356.1326692009@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Thomas Munro <munro(at)ip9(dot)org> writes:
> I am wondering out loud whether I am brave enough to try to propose
> SKIP LOCKED DATA support and would be grateful for any feedback and/or
> {en|dis}couragement. I don't see it on the todo list, and didn't find
> signs of others working on this (did I miss something?), but there are
> examples of users asking for this feature (by various names) on the
> mailing lists. Has the idea already been rejected, is it
> fundamentally infeasible for some glaring reason, or far too
> complicated for new players?

It sounds to me like "silently give the wrong answers". Are you sure
there are not better, more deterministic ways to solve your problem?

(Or in other words: the fact that Oracle has it isn't enough to persuade
me it's a good idea.)

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jaime Casanova 2012-01-16 06:23:30 Re: patch : Allow toast tables to be moved to a different tablespace
Previous Message Kevin Grittner 2012-01-16 04:05:09 triggered_change_notification v3