On Mon, 24 Mar 2025 at 18:57, Olivier Miquel <[email protected]> wrote:
>
>
> Yes you're right! Sorry, i had swapped the two results. It is way slower
> with 10.11.
>
> I could add an index on recipient, but why this is so faster with 10.3
> without any indexes ?

What do you get from:
ANALYZE select count(recipient) from transactions;

> I'm guessing that there's something i missed here.

Same disks, same file system?

-- 
Gordan Bobic
Database Specialist, Shattered Silicon Ltd.
https://shatteredsilicon.net
_______________________________________________
discuss mailing list -- [email protected]
To unsubscribe send an email to [email protected]

Reply via email to