Re: [PERFORM] Stored procedure slower than sql?

2006-10-26 Thread Matthew Peters
partition_constraint_column = $2; $$ LANGUAGE SQL; Matthew A. Peters Sr. Software Engineer, Haydrian Corp. [EMAIL PROTECTED] (mobile) 425-941-6566 Haydrian Corp. -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Thursday, October 26, 2006 9:15 AM To: Matthew Peters Cc: pgsql-performance

[PERFORM] Stored procedure slower than sql?

2006-10-26 Thread Matthew Peters
:text, 2, 1) = '5'::text) AND (table_key = 10265512) AND (date_part('year'::text, (event_date)::timestamp without time zone) = 2005::double precision))   ->  Seq Scan on table5_p12 table5  (cost=0.00..2089.95 rows=1 width=