Changes between Initial Version and Version 1 of Ticket #35977, comment 3
- Timestamp:
- Dec 6, 2024, 9:23:59 AM (12 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #35977, comment 3
initial v1 1 1 Agree with Sarah here! 2 2 3 The lack of ordering consistency when retrieving objects from the database **without an explicit ordering** is not specified is nota Postgres or serialization specific problem.3 The lack of ordering consistency when retrieving objects from the database **without an explicit ordering** is not a Postgres or serialization specific problem. 4 4 5 5 When no `ORDERY BY` is specified the database can choose to return values in the order it wants which is usually the fastest one. In the case of database like MySQL that usually means by primary key as that's how the data is clustered/organized on disk while on Postgres it depends on multiple factors.