Re: Performance on Bulk Insert to Partitioned Table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Charles Gomes <charlesrg(at)outlook(dot)com>
Cc: Ondrej Ivanič <ondrej(dot)ivanic(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Performance on Bulk Insert to Partitioned Table
Date: 2012-12-20 23:39:07
Message-ID: 27306.1356046747@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Charles Gomes <charlesrg(at)outlook(dot)com> writes:
> Using rules would be totally bad as I'm partitioning daily and after one year having 365 lines of IF won't be fun to maintain.

You should probably rethink that plan anyway. The existing support for
partitioning is not meant to support hundreds of partitions; you're
going to be bleeding performance in a lot of places if you insist on
doing that.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2012-12-21 00:19:52 Re: Performance on Bulk Insert to Partitioned Table
Previous Message Charles Gomes 2012-12-20 22:59:18 Re: Performance on Bulk Insert to Partitioned Table