Skip site navigation (1) Skip section navigation (2)

Re: NOLOGGING option, or ?

From: Joe Conway <mail(at)joeconway(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Alon Goldshuv <agoldshuv(at)greenplum(dot)com>,pgsql-hackers(at)postgresql(dot)org
Subject: Re: NOLOGGING option, or ?
Date: 2005-06-01 23:06:09
Message-ID: 429E3F61.8040003@joeconway.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Simon Riggs wrote:
> On Wed, 2005-06-01 at 10:35 -0700, Alon Goldshuv wrote:
>>2) A modified command syntax for introducing a direct single row error
>>handling. By direct I mean - a row that if rejected from within the COPY

>>5) allow an ERRORLIMIT to allow control of aborting a load after a certain
>>number of errors (and a pre-requisite for this is point number 2 above).

> 2) and 5) seem critical for combined usability & performance with real
> world data.

I'll second that! This would be a huge win for one of my real world 
applications, whether implemented as a new command, or as added 
capability on top of COPY. The other performance enhancements would 
certainly be nice to have also, but in my experience not nearly as 
important as these two.

Joe

In response to

pgsql-hackers by date

Next:From: Alon GoldshuvDate: 2005-06-01 23:29:30
Subject: Re: NOLOGGING option, or ?
Previous:From: Bruce MomjianDate: 2005-06-01 23:06:07
Subject: Re: NOLOGGING option, or ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group