News for hackers. Stuff that matters.
Re:PostgreSQL is the worlds’ best database by yjftsjthsd-h on Friday April 03, 2020 @09:41AM (#22769027)
And compression! I've gotten compression ratios above 3x on real production databases, which is the difference between "we need more disks by next month" and "this hardware will last the foreseeable future". Not to mention that it improves performance when lz4 can decompress faster than the disks can read.
Re:PostgreSQL is the worlds’ best database by od0 on Saturday April 04, 2020 @07:38PM (#22782417)
I'm getting almost 4x on a 10TB production database! A little surprising the first time you see all the z_wr_iss processes flying :)