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

Re: Using multi-row technique with COPY

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Using multi-row technique with COPY
Date: 2005-11-27 22:45:31
Message-ID: 7456.1133131531@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
> COPY FROM can read in sufficient rows until it has a whole block worth
> of data, then get a new block and write it all with one pair of
> BufferLock calls.

> Comments?

I don't see any way to do this without horrible modularity violations.
The COPY code has no business going anywhere near individual buffers;
for that matter, it doesn't even really know what "a block worth" of
data is, since the tuples it's dealing with aren't toasted yet.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Michael FuhrDate: 2005-11-27 23:57:10
Subject: Array comparisons involving NULL
Previous:From: Simon RiggsDate: 2005-11-27 19:44:55
Subject: Using multi-row technique with COPY

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