On Sat, Jan 12, 2013 at 7:41 PM, Horst Dehmer <horst.deh...@gmail.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) -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance