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-08-01 07:45:54
Message-ID: 81132473206F3A46A72BD6116E1A06AE3EC27A@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. Is this
known problem?

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

Tambet

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2003-08-01 07:46:18 Re: Comments in .sql files
Previous Message Dennis Gearon 2003-08-01 04:23:51 Re: Table Stats