PostgreSQL Synchronized Sequential Scans and LIMIT without an ORDER BY
TL;DR: if you want predictable results with LIMIT or FETCH FIRST in any database, you need an ORDER...
Tags: postgres, sql, database, fullscan