Postgres Pro
Downloads
Home   >   mailing lists

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

From Alex Vinogradovs
Subject Rules slower than Dynamic SQL ?
Date
Msg-id 1196121679.1152.40.camel@localhost
Whole thread Raw
Responses Re: Rules slower than Dynamic SQL ?  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Wes
Date:
Subject: Re: Linux v.s. Mac OS-X Performance
Next
From: Simon Riggs
Date:
Subject: Re: Rules slower than Dynamic SQL ?