Postgres Pro
Downloads
Home   >   mailing lists

Re: Rules slower than Dynamic SQL ? - Mailing list pgsql-general

From Simon Riggs
Subject Re: Rules slower than Dynamic SQL ?
Date
Msg-id 1196122164.4246.850.camel@ebony.site
Whole thread Raw
In response to Rules slower than Dynamic SQL ?  (Alex Vinogradovs <AVinogradovs@Clearpathnet.com>)
Responses Re: Rules slower than Dynamic SQL ?  (Decibel! <decibel@decibel.org>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Alex Vinogradovs
Date:
Subject: Rules slower than Dynamic SQL ?
Next
From: Craig White
Date:
Subject: Re: Linux v.s. Mac OS-X Performance