Re: Partitioning option for COPY - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Partitioning option for COPY
Date
Msg-id 4AFB6279.1070207@agliodbs.com
Whole thread Raw
In response to Re: Partitioning option for COPY  (Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
List pgsql-hackers
> We can use an INSERT trigger to route tuples into partitions even now.
> Why do you need an additional router for COPY?  Also, it would be nicer
> that the router can works not only in COPY but also in INSERT.

Yeah, but performance on an insert trigger is impractical for large
volumes of data.

--Josh Berkus



pgsql-hackers by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: Listen / Notify rewrite
Next
From: Andrew Gierth
Date:
Subject: NULL-handling in aggregate(DISTINCT ...)