[GENERAL] limitby without orderby

Hi Gurus, What is difference between select * from items order by random() limit 5; and select * items limit 5; my basic requirement is to get random rows from a table, my where clause will make sure I won't get same rows in repeated execution of above queries. -- Regards

[GENERAL] Queries related to checkpoints

Hi, I am a Noob with db tuning and trying to analyze pg_stats_brwriter data checkpoints_timed | checkpoints_req | buffers_checkpoint | buffers_clean | maxwritten_clean | buffers_backend | buffers_alloc ---+-++---+--