[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    [GENERAL] COPY and domains
From:       "Tambet Matiisen" <t.matiisen () aprote ! ee>
Date:       2003-07-31 11:42:33
[Download RAW message or body]


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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

[prev in list] [next in list] [prev in thread] [next in thread]