Torsten Förtsch wrote:
> Is there an other way to make the planner use generate the 1st
> plan?
The planner cost factors are based on the assumption that a
moderate percentage of random page reads will need to actually go
out to disk. If a high percentage of pages are in cache, you may
want to
Hi,
depending on the OFFSET parameter I have seen at least 3 different query
plans.
SELECT * FROM
(
SELECT * FROM transaction tt
WHERE
tt.account_id = '1376641'
AND tt.transaction_time >= '2013-02-03 05:37:24'
AND tt.transaction_time < '2013-08-23 05:37:24
