"Tiago D. Jacobs - iMDT" <tiago(at)imdt(dot)com(dot)br> writes:
> ( 5 ) Here's the problem (it returns without breaking by timeout):
Hm, works fine here:
ERROR: canceling statement due to statement timeout
CONTEXT: SQL statement "SELECT i.item_name::text As row_name,
to_char(if.action_date, 'mon')::text As bucket,
SUM(if.num_used)::integer As bucketvalue
FROM inventory As i INNER JOIN inventory_flow As if
ON i.item_id = if.item_id
AND action_date BETWEEN date '2007-01-01' and date '2007-12-31
23:59'
GROUP BY i.item_name, to_char(if.action_date, 'mon'),
date_part('month', if.action_date)
ORDER BY i.item_name"
How long does the query run on your machine? If it's less than 10ms,
maybe what you're seeing is just that the resolution of
statement_timeout isn't necessarily less than 10ms, depending on
platform.
What is the platform, anyway? And what Postgres version?
regards, tom lane