Horton

Re: Partitioning option for COPY

Josh Berkus <josh@agliodbs.com>

View thread View on postgr.es
From: Josh Berkus <josh@agliodbs.com>
To: Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Cc: Emmanuel Cecchet <manu@asterdata.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2009-11-12T01:18:49Z
Lists: 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