Re: [GENERAL] Perl::DBI and interval syntax [side question]

2005-11-08 Thread MaXX
Tom Lane wrote: > MaXX <[EMAIL PROTECTED]> writes: >> Can this be the cause of a huge loss of perf? I have the following query >> in a Perl script using DBI + DBD::Pg, AutoCommit => 0: >> SELECT stats_put_sources(?, ?, int4(?), int4(?)) >> This syntax runs almost 10x faster than: >> SELECT stats_p

Re: [GENERAL] Perl::DBI and interval syntax [side question]

2005-11-08 Thread Tom Lane
MaXX <[EMAIL PROTECTED]> writes: > Can this be the cause of a huge loss of perf? I have the following query in > a Perl script using DBI + DBD::Pg, AutoCommit => 0: > SELECT stats_put_sources(?, ?, int4(?), int4(?)) > This syntax runs almost 10x faster than: > SELECT stats_put_sources(?, ?, ?::int4

Re: [GENERAL] Perl::DBI and interval syntax [side question]

2005-11-08 Thread MaXX
Martijn van Oosterhout wrote: > On Mon, Nov 07, 2005 at 05:58:04PM -0500, Tom Lane wrote: >> Allen <[EMAIL PROTECTED]> writes: >> > SELECT count(*) from post where post_ts >= current_date - interval ? >> This is not right, and never has been right, even though it may have >> accidentally failed to