MaXX <bs139412(at)skynet(dot)be> 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, ?::int4)
You probably have no idea how hard that is to believe --- they should
certainly be just the same. Let's see a self-contained test case that
exhibits this problem.
regards, tom lane