COPY and domains - Mailing list pgsql-general

From Tambet Matiisen
Subject COPY and domains
Date
Msg-id 81132473206F3A46A72BD6116E1A06AE3EC27A@black.aprote.com
Whole thread Raw
Responses Re: COPY and domains  (Richard Huxton <dev@archonet.com>)
List 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

pgsql-general by date:

Previous
From: Francisco J Reyes
Date:
Subject: Re: Hardware selection
Next
From: Ian Harding
Date:
Subject: Errors from Sub-select Not Showing Up