From:
Simon Riggs <simon(at)2ndquadrant(dot)com>
To:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>,Greg Stark <gsstark(at)mit(dot)edu>, Neil Conway <neilc(at)samurai(dot)com>,Alvaro Herrera <alvherre(at)surnet(dot)cl>, pgsql-hackers(at)postgresql(dot)org
Subject:
Re: NOLOGGING option, or ?
Date:
2005-06-01 22:47:17
Message-ID:
1117666037.3844.1127.camel@localhost.localdomain (view raw or flat )
Thread:
2005-05-31 23:01:43 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2005-06-01 02:47:30 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-06-01 04:40:07 from Alvaro Herrera <alvherre(at)surnet(dot)cl>
2005-06-01 05:00:04 from Neil Conway <neilc(at)samurai(dot)com>
2005-06-01 08:21:39 from Greg Stark <gsstark(at)mit(dot)edu>
2005-06-01 08:44:24 from Greg Stark <gsstark(at)mit(dot)edu>
2005-06-01 12:03:25 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2005-06-01 13:39:07 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-01 13:58:53 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-06-01 14:12:18 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-01 14:18:25 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-06-01 15:21:07 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2005-06-01 15:55:46 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-06-01 17:55:46 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2005-06-01 18:10:45 from Alvaro Herrera <alvherre(at)surnet(dot)cl>
2005-06-01 18:24:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-06-01 20:17:39 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2005-06-01 18:14:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-06-01 20:33:24 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2005-06-01 22:05:13 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-01 22:32:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-06-01 22:47:17 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2005-06-01 23:02:17 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-01 22:37:51 from Hannu Krosing <hannu(at)tm(dot)ee>
2005-06-01 14:07:37 from Jochem van Dieten <jochemd(at)gmail(dot)com>
2005-06-01 14:14:42 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-01 15:43:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-06-01 16:00:28 from Jochem van Dieten <jochemd(at)gmail(dot)com>
2005-06-01 21:27:01 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-01 08:16:46 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2005-06-01 08:34:38 from Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
2005-06-01 11:54:19 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2005-06-01 14:01:06 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-06-01 09:54:58 from Hannu Krosing <hannu(at)skype(dot)net>
2005-06-01 17:35:30 from "Alon Goldshuv" <agoldshuv(at)greenplum(dot)com>
2005-06-01 21:56:07 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-01 22:18:41 from "Luke Lonergan" <llonergan(at)greenplum(dot)com>
2005-06-01 22:37:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-06-02 00:05:29 from "Luke Lonergan" <llonergan(at)greenplum(dot)com>
2005-06-02 01:05:11 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-02 01:54:51 from "Luke Lonergan" <llonergan(at)greenplum(dot)com>
2005-06-02 02:27:51 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-02 02:40:06 from "Luke Lonergan" <llonergan(at)greenplum(dot)com>
2005-06-01 23:00:34 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-01 23:29:30 from "Alon Goldshuv" <agoldshuv(at)greenplum(dot)com>
2005-06-02 01:01:56 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-02 01:50:23 from "Luke Lonergan" <llonergan(at)greenplum(dot)com>
2005-06-02 02:13:38 from Oliver Jowett <oliver(at)opencloud(dot)com>
2005-06-02 02:28:41 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-02 02:35:33 from "Luke Lonergan" <llonergan(at)greenplum(dot)com>
2005-06-02 02:47:26 from Steve Atkins <steve(at)blighty(dot)com>
2005-06-02 03:35:57 from "Luke Lonergan" <llonergan(at)greenplum(dot)com>
2005-06-02 05:16:34 from "Luke Lonergan" <llonergan(at)greenplum(dot)com>
2005-06-01 22:39:59 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2005-06-01 23:06:07 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-01 23:06:09 from Joe Conway <mail(at)joeconway(dot)com>
2005-06-02 03:41:29 from Alvaro Herrera <alvherre(at)surnet(dot)cl>
2005-06-02 16:54:56 from "Alon Goldshuv" <agoldshuv(at)greenplum(dot)com>
2005-06-01 06:25:42 from Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>
2005-06-01 14:43:44 from Dawid Kuroczko <qnex42(at)gmail(dot)com>
2005-06-01 12:10:55 from Hannu Krosing <hannu(at)skype(dot)net>
2005-06-01 15:31:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-06-01 16:18:09 from Hannu Krosing <hannu(at)tm(dot)ee>
2005-06-01 17:00:28 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2005-06-01 17:18:55 from Alvaro Herrera <alvherre(at)surnet(dot)cl>
2005-06-01 17:35:25 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Lists:
pgsql-hackers
On Wed, 2005-06-01 at 18:32 -0400, Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > One idea would be to look at the table file size first. If it has zero
> > blocks, lock the table and if it still has zero blocks, do the no-WAL
> > copy.
>
> I think that's a bad idea. It would make the behavior unpredictable
> --- sometimes a COPY will take an exclusive lock, and other times not;
> and the reason why is at a lower semantic level than the user is
> supposed to know about.
>
> Before you say "this is not important", consider the nontrivial risk
> that the stronger lock will cause a deadlock failure. I don't think
> that it's acceptable for lock strength to be unpredictable.
While I agree with Bruce's sentiment, the locking is an issue with
COPY.
It is particularly important to be able to plan the concurrency within
an application. That is why DB2's interesting ability to perform lock
upgrades in a relatively unpredictable manner is not good.
For CREATE TABLE AS SELECT, I think we could do this Bruce's way and
win, since we would take the same grade of lock in both cases.
Best Regards, Simon Riggs
In response to
pgsql-hackers by date
Next :From: Bruce MomjianDate: 2005-06-01 23:00:34Subject : Re: NOLOGGING option, or ?Previous :From : Simon RiggsDate : 2005-06-01 22:39:59Subject : Re: NOLOGGING option, or ?
