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.
[ Parent
| on HN ]
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..