What is the fastest query in PostgreSQL, which I can use as a validationQuery binding a JNDI resource?
I though that
SELECT 1 is the simplest, but in this document it is said that in PostgreSQL we should use
select version(). This is not obvious to me.
I've tried to compare
EXPLAIN ANALYZE SELECT 1 and
EXPLAIN ANALYZE SELECT VERSION() and still can't see why second one is (or should be) faster.