Re: Idea for improving speed of pg_restore - Mailing list pgsql-general

From Tom Lane
Subject Re: Idea for improving speed of pg_restore
Date
Msg-id 29050.1063772208@sss.pgh.pa.us
Whole thread Raw
In response to Re: Idea for improving speed of pg_restore  ("scott.marlowe" <scott.marlowe@ihs.com>)
Responses Re: Idea for improving speed of pg_restore  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Re: Idea for improving speed of pg_restore  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
"scott.marlowe" <scott.marlowe@ihs.com> writes:
> Not so sure on whether the foot gun is a good idea.  We already have .22
> calibre foot gun (fsync) that makes for pretty big improvements in load
> speed, and we see people all the time on General and Performance running
> production servers with it turned off.  You know as well as I do the
> second we make WAL optional, some people are gonna start running
> production servers with it.

Well, yeah, they will.  On a noncritical server, is that a sin?  I mean,
if we offer fsync-off, it's not clear to me that offering WAL-off makes
the difference between venial and mortal sin.  Seems to me we're just
putting the weapons in the display case.  fsync = .22, WAL = .45,
but you shoot your foot with either one it's still gonna ruin your day.

            regards, tom lane

pgsql-general by date:

Previous
From: Robert Creager
Date:
Subject: Re: State of Beta 2
Next
From: Dennis Gearon
Date:
Subject: Re: State of Beta 2