News for hackers. Stuff that matters.
Re:PostgreSQL is the worlds’ best database by pritambarhate on Friday April 03, 2020 @11:00AM (#22769847)
Can you please give us more info about your workload? Is it very high throughput DB? Especially for Inserts and Updates? I searched on ZFS and PostgreSQL performance a couple of years ago on the Internet and popular opinion seems to be databases with Copy on Write type of file systems don't give the best performance.
Re:PostgreSQL is the worlds’ best database by riku_iki on Friday April 03, 2020 @01:08PM (#22771565)
I am not deep expert, but my impression is that Postgres MVCC is kinda Copy on Write approach already (no in place updates, but you write new page for each update), so it should be perfect marriage..
Re:PostgreSQL is the worlds’ best database by ggm on Friday April 03, 2020 @03:16PM (#22773019)
I'm on a read-mostly DB. few clients, but constant loads. More inserts than updates.