3 ms·
I'm curious how much of the underlying pgsql storage engine was rewritten since Aurora/MySQL uses a completely different engine than the default InnoDB.
by dhd415 10y ago
I'm curious how much of the underlying pgsql storage engine was rewritten since Aurora/MySQL uses a completely different engine than the default InnoDB.
- scosman 10y agoI doubt much. Aurora looks more like those engines running on an EFS disk than a major rewrite of the storage engines themselves. They need to disable some features to make concurrent readers on the same network disk work. I'm sure it's harder than I'm making it sound, but I don't think it's a new storage engine beyond the disk level.
- dhd415 10y agoI suspect you're right. I wonder if that's part of the reason why they claim a lower performance improvement of 2x over "standard" pgsql installations rather than the 5x improvement of Aurora/MySQL over standard MySQL installations. If so, though, hopefully there's a silver lining of faster incorporation of new pgsql features into the Aurora/PG service.