pg_stat_bgwriter

Dear I would like to share with you to see what you think about the statistics of pg_stat_bgwriter postgres = # select * from pg_stat_bgwriter;  checkpoints_timed | checkpoints_req | checkpoint_write_time | checkpoint_sync_time | buffers_checkpoint | buffers_clean | maxwritten_clean | buffers_back

Re: Optimising a two column OR check

On Sat, 12 Oct 2019 at 17:16, Andrew Gierth wrote: > > "Ivan" == Ivan Voras writes: > > Ivan> SELECT user1_id,user2_id FROM friend WHERE user1_id=42 OR > user2_id=42; > > To get friends of user 42: > > SELECT user1_id FROM friend WHERE user2_id=42 > UNION ALL > SELECT user2_id FROM friend