Re: Rules slower than Dynamic SQL ?

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Alex Vinogradovs <AVinogradovs(at)Clearpathnet(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Rules slower than Dynamic SQL ?
Date: 2007-11-27 00:09:24
Message-ID: 1196122164.4246.850.camel@ebony.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 2007-11-26 at 16:01 -0800, Alex Vinogradovs wrote:

> 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 ?

Depends how complex your rules are, but I think yes is the short answer.

--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig White 2007-11-27 01:19:43 Re: Linux v.s. Mac OS-X Performance
Previous Message Alex Vinogradovs 2007-11-27 00:01:19 Rules slower than Dynamic SQL ?