3 ms·
> > If you use another SQL database, the best thing to do is to use UUIDv4 as primary key, and use "ORDER BY pk LIMIT size". > What if I want a different rando
by acatton 3y ago
> > If you use another SQL database, the best thing to do is to use UUIDv4 as primary key, and use "ORDER BY pk LIMIT size".
> What if I want a different random order tomorrow?
If your data is large, and you want different samples. You can always always "select * from pk > gen_random_uuid() order by pk limit 10"
You have a very small chance to get ffffffff-... and get zero elements.
This is not perfect, I admit, but ORDER BY random() is one of the most wasteful thing.
If getting random samples is very important, the best you can you is migrate to postgres and use TABLESAMPLE.