On 5/10/2012 2:00 PM, Lee Hachadoorian wrote:
On Thu, May 10, 2012 at 2:42 PM, Andy Colson wrote:
On 5/10/2012 1:10 PM, Lee Hachadoorian wrote:
2) Is there a performance hit to doing a COPY to more than one table
in the same transaction?
No, I don't think so. I assume you are the only use
On Thu, May 10, 2012 at 2:42 PM, Andy Colson wrote:
> On 5/10/2012 1:10 PM, Lee Hachadoorian wrote:
>>
>> 2) Is there a performance hit to doing a COPY to more than one table
>> in the same transaction?
>
>
> No, I don't think so. I assume you are the only user hitting the
> import_table, so hold
On 5/10/2012 1:10 PM, Lee Hachadoorian wrote:
Does anyone have experience or advice on how to efficiently issue a
large number of COPY statements? The data (US Census) comes in> 100
"segments" (each will be copied to its own database tables) for each
state (51), for a total of> 5000 text files.
Does anyone have experience or advice on how to efficiently issue a
large number of COPY statements? The data (US Census) comes in > 100
"segments" (each will be copied to its own database tables) for each
state (51), for a total of > 5000 text files. I can generate the COPY
statements with a scrip
