On Mon, Jun 15, 2009 at 7:47 PM, Anj Adu <[email protected]> wrote:
> We currently use triggers with static if..then..else statements to > determine which partition the data goes into. Would there be a performance > impact if we were to use dynamic sql to achieve the same ?. The issue with > static triggers is the maintenance overhead of having to redefine the > triggers periodically. The dynamic sql is simple and involves building a sql > string with just a to_char(date_Field) to determine which partition the data > goes into and the trigger will never have to be re-defined. > > There will be some performance degradation, but you'll have to test measure it and decide if it is acceptable to you vs. the maintenance overhead. Best regards, -- Lets call it Postgres EnterpriseDB http://www.enterprisedb.com gurjeet[[email protected] singh.gurj...@{ gmail | hotmail | indiatimes | yahoo }.com Mail sent from my BlackLaptop device
