Rules slower than Dynamic SQL ?

From: Alex Vinogradovs <AVinogradovs(at)Clearpathnet(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Rules slower than Dynamic SQL ?
Date: 2007-11-27 00:01:19
Message-ID: 1196121679.1152.40.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I've got a data warehouse with pretty high rate of insert into
partitioned tables. What I've noticed, is that rule-based partitioning
seems to be somewhat slower than insertions made directly into
partitions through execution of dynamic SQL.

Is it really true ?

Thanks!

Best regards,
Alex Vinogradovs

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Simon Riggs 2007-11-27 00:09:24 Re: Rules slower than Dynamic SQL ?
Previous Message Wes 2007-11-26 23:37:50 Re: Linux v.s. Mac OS-X Performance