COPY and domains

From: "Tambet Matiisen" <t(dot)matiisen(at)aprote(dot)ee>
To: <pgsql-general(at)postgresql(dot)org>
Subject: COPY and domains
Date: 2003-07-31 11:42:33
Message-ID: 81132473206F3A46A72BD6116E1A06AE1B15BA@black.aprote.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I noticed that COPY is getting very slow, when importing to table, which
makes use of domains as column datatypes. It seems like foreign key
validation is especially slow. It takes ages to import table with 25000
rows, which has foreign key reference to another table with 25000 rows.
I tried the same tables without domains and it was much faster.

PostgreSQL 7.3.2 on i386-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3.

Tambet

Browse pgsql-general by date

  From Date Subject
Next Message Steffen Macke 2003-07-31 11:46:02 Correct Allocation of UNICODE string in C
Previous Message Stephan Szabo 2003-07-31 10:56:33 Re: CREATE TABLE with a column of type {table name}