From:
Hannu Krosing <hannu(at)skype(dot)net>
To:
Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>,Neil Conway <neilc(at)samurai(dot)com>, Alvaro Herrera <alvherre(at)surnet(dot)cl>,Alon Goldshuv <agoldshuv(at)greenplum(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject:
Re: NOLOGGING option, or ?
Date:
2005-06-01 09:54:58
Message-ID:
1117619698.4772.14.camel@fuji.krosing.net (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 K, 2005-06-01 at 09:16 +0100, Simon Riggs wrote:
> On Tue, 2005-05-31 at 22:47 -0400, Tom Lane wrote:
> > Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
> > > Recent test results have shown a substantial performance improvement
> > > (+25%) if WAL logging is disabled for large COPY statements.
> >
> > How much of that is left after we fix the 64-bit-CRC issue?
>
> Well, I don't know. The I/O is the main thing I'm trying to avoid.
While avoiding IO is a good thing in general, WAL IO traffic can at
least easily made parallel to other IO by allocating own disk for WAL.
> > > Now, I would like to discuss adding an enable_logging USERSET GUC,
> >
> > [ fear and loathing ... ]
>
> OK. I needed to say the idea, to make sure we had considered it. I now
> pronounce it dead and buried.
>
> > BTW, I'm sure you are the last one who needs to be reminded that
> > any such thing breaks PITR completely.
I don't think we do any WAlling of TEMP tables, so it may be easy to
extend this to any table with 'NO_WAL' bit set.
That would create kind of 'extended temp table' - unsafe but fast ;)
--
Hannu Krosing <hannu(at)skype(dot)net>
In response to
pgsql-hackers by date
Next :From: Zeugswetter Andreas DAZ SDDate: 2005-06-01 11:07:57Subject : Re: Tablespace-level Block Size DefinitionsPrevious :From : Mark Cave-AylandDate : 2005-06-01 09:27:41Subject : Re: Cost of XLogInsert CRC calculations
