Re: copy csv into partitioned table with unique index

From: legrand legrand <legrand_legrand(at)hotmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: copy csv into partitioned table with unique index
Date: 2018-01-28 10:55:38
Message-ID: 1517136938387-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Did you try to transform your temp table into a table partition using the
ALTER TABLE ATTACH syntax
https://www.postgresql.org/docs/10/static/ddl-partitioning.html

Regards
PAscal

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Lars Aksel Opsahl 2018-01-28 11:57:53 SV: copy csv into partitioned table with unique index
Previous Message Mariel Cherkassky 2018-01-28 09:11:33 copy csv into partitioned table with unique index