Re: postgres external table

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Greg Smith <greg(at)2ndquadrant(dot)com>, Amy Smith <vah123(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: postgres external table
Date: 2010-01-19 04:41:19
Message-ID: 4B5537EF.3060007@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bret S. Lambert 2010-01-19 05:17:45 Re: data dump help
Previous Message Scott Marlowe 2010-01-19 02:28:53 Re: vacuum issues under load?