Re: postgres external table - Mailing list pgsql-general

From Craig Ringer
Subject Re: postgres external table
Date
Msg-id 4B5537EF.3060007@postnewspapers.com.au
Whole thread Raw
In response to Re: postgres external table  (Vincenzo Romano <vincenzo.romano@notorand.it>)
Responses Re: postgres external table  (Greg Stark <gsstark@mit.edu>)
Re: postgres external table  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-general
On 19/01/2010 1:13 AM, Vincenzo Romano wrote:

> Another case, Tom, could be when the file is updated from a non-DB
> application and you need to synchronize
> the data with other DB applications ...

How can that work without a transactional file system, though? If the
external process writes to the file while you're half-way through
reading it, what's the database to do? In general, how do external
tables cope with the fact that they're on non-transactional storage?

--
Craig Ringer

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: vacuum issues under load?
Next
From: "Bret S. Lambert"
Date:
Subject: Re: data dump help