From:
Andrew Dunstan <andrew(at)dunslane(dot)net>
To:
Csaba Nagy <ncslists(at)googlemail(dot)com>
Cc:
Robert Haas <robertmhaas(at)gmail(dot)com>,
Jaime Casanova <jaime(at)2ndquadrant(dot)com>,
Daniel Loureiro <loureirorg(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject:
Re: DELETE with LIMIT (or my first hack)
Date:
2010-11-30 15:14:21
Message-ID:
4CF514CD.6040201@dunslane.net (view raw or flat )
Thread:
2010-11-30 02:08:02 from Daniel Loureiro <loureirorg(at)gmail(dot)com>
2010-11-30 02:33:56 from Jaime Casanova <jaime(at)2ndquadrant(dot)com>
2010-11-30 02:55:00 from Daniel Loureiro <loureirorg(at)gmail(dot)com>
2010-11-30 03:09:15 from Jaime Casanova <jaime(at)2ndquadrant(dot)com>
2010-11-30 03:19:22 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-30 04:25:17 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2010-11-30 05:05:12 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-30 09:25:01 from Csaba Nagy <ncslists(at)googlemail(dot)com>
2010-11-30 14:19:26 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-30 14:57:13 from Csaba Nagy <ncslists(at)googlemail(dot)com>
2010-11-30 15:14:21 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2010-11-30 16:33:07 from Daniel Loureiro <daniel(at)termasa(dot)com(dot)br>
2010-11-30 18:04:17 from Daniel Loureiro <loureirorg(at)gmail(dot)com>
2010-11-30 22:01:02 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-12-01 01:57:56 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-12-01 11:01:04 from Daniel Loureiro <loureirorg(at)gmail(dot)com>
2010-12-01 11:46:49 from Valentine Gogichashvili <valgog(at)gmail(dot)com>
2010-12-01 13:11:25 from Marko Tiikkaja <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi>
2010-12-01 14:37:22 from Rob Wultsch <wultsch(at)gmail(dot)com>
2010-12-01 14:51:35 from Mario Weilguni <roadrunner6(at)gmx(dot)at>
2010-12-01 15:13:32 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-12-01 18:08:49 from Dmitriy Igrishin <dmitigr(at)gmail(dot)com>
2010-11-30 19:12:54 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-11-30 19:20:00 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2010-11-30 19:24:52 from Marko Tiikkaja <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi>
2010-11-30 19:47:24 from Marko Tiikkaja <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi>
2010-11-30 21:08:25 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-30 20:16:57 from Andres Freund <andres(at)anarazel(dot)de>
2010-11-30 20:34:42 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2010-11-30 21:10:55 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-11-30 20:26:11 from Alastair Turner <bell(at)ctrlf5(dot)co(dot)za>
2010-12-01 19:19:03 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2010-12-03 00:12:50 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-12-03 00:14:27 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-03 00:26:35 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-12-01 18:07:11 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-11-30 15:04:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-30 15:41:19 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-30 16:04:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-30 16:12:01 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-30 19:45:39 from Jeff Davis <pgsql(at)j-davis(dot)com>
2010-11-30 20:52:36 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-30 21:18:15 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-30 22:21:07 from Jeff Davis <pgsql(at)j-davis(dot)com>
2010-11-30 05:50:55 from Marti Raudsepp <marti(at)juffo(dot)org>
2010-11-30 13:26:37 from Rob Wultsch <wultsch(at)gmail(dot)com>
2010-11-30 03:11:47 from Robert Haas <robertmhaas(at)gmail(dot)com>
Lists:
pgsql-hackers
On 11/30/2010 09:57 AM, Csaba Nagy wrote:
>
> So it is really an ideological thing and not lack of demand or
> implementation attempts... I for myself can't write working C code
> anyway, so I got my peace with the workaround - I wish you good luck
> arguing Tom :-)
>
>
We need a convincing use case for it. So far the only one that's seemed
at all convincing to me is the one about deleting in batches. But that
might be enough.
As for it being illogical, I don't think it's any more so than
DELETE FROM foo WHERE random() < 0.1;
and you can do that today.
cheers
andrew
In response to
Responses
pgsql-hackers by date
Next :From: Heikki LinnakangasDate: 2010-11-30 15:26:27Subject : Re: GiST insert algorithm rewritePrevious :From : Tom LaneDate : 2010-11-30 15:04:20Subject : Re: DELETE with LIMIT (or my first hack)
