Re: Perl::DBI and interval syntax [side question] - Mailing list pgsql-general

MaXX <bs139412@skynet.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