Re: COPY with high # of clients, partitioned table locking issues?

On Wed, Mar 30, 2011 at 5:48 PM, Bob Lunney <bob_lunney(at)yahoo(dot)com> wrote:

> John,
>
> Sorry to hear you're struggling with such underpowered hardware. ;-) A
> little more information would be helpful, though:
>
> 1. What version of PG are you running?
> 2. What are the constraints on the child tables?
> 3. How many rows does each copy insert?
> 4. Are these wrapped in transactions?
> 5. are the child tables created at the same time the copies are taking
> place? In the same transaction?
> 6. Are the indexes in place on the child table(s) when the copies are
> running? Do they have to be to validate the data?
> 7. What are the configuration settings for the database? (Just the ones
> changed from the default, please.)
> 8. Which file system are you running for the database files? Mount
> options?
> 9. Are the WAL files on the same file system?
>
>
10. are you copying directly into the child tables or into the parent and
then redirecting to child tables via a trigger?