MaXX <bs139412@xxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
