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
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
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