Re: Insert performance for large transaction with multiple COPY FROM

From: Claudio Freire <klaussfreire(at)gmail(dot)com>
To: Horst Dehmer <horst(dot)dehmer(at)gmail(dot)com>
Cc: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Insert performance for large transaction with multiple COPY FROM
Date: 2013-01-13 01:52:46
Message-ID: CAGTBQpY4EF=B-5dPZLs5+nDQTxY2u166sR8AY_GNro2uyt1VNg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Sat, Jan 12, 2013 at 7:41 PM, Horst Dehmer <horst(dot)dehmer(at)gmail(dot)com> wrote:
> Since the complete schema (of about 300 tables) is generated, I will just try char(20) instead of numeric(20) in the next days to see if it makes any difference. Which I somehow doubt.

I think that might just make it worse.

Well, maybe the others were right, and it's just that you're hitting
the disk on that particular table.

That, or it's all those CHECK constraints. Have you tried removing the
CHECK constraints (they're a heapload of function calls)

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Alexandre de Arruda Paes 2013-01-13 21:49:18 From TODO: Simplify creation of partitioned tables
Previous Message Horst Dehmer 2013-01-12 22:41:53 Re: Insert performance for large transaction with multiple COPY FROM