4 ms·
Well as a postgres/sybase dba, there are several management features I miss in postgres. For one, when there is no space left for wals, your instance juste cra
by grumpydba 9y ago
Well as a postgres/sybase dba, there are several management features I miss in postgres.
For one, when there is no space left for wals, your instance juste crashes. In sybase/mssql your processes would just be suspended untill you add some disk space.
Also, spreading your databases on several disks is way easier. On postrgres adding tablespaces makes pg_basebackup lose functionality.
Those are some several limitations that the developper might not see, but they impact availlability.
Also, reclaiming unused space online can be tedious, and failover from one instance to another is not easy. You have to use 3rd party tools such as repman to do so.
All of thoses missing features have caused several outages and should be addresses in my opinion to be able to meet the needs of the most demanding workloads.
Still, I view postgres as the best solution for most business cases.
- orf 9y ago> For one, when there is no space left for wals, your instance juste crashes. In sybase/mssql your processes would just be suspended untill you add some disk space. Are these not equivalent from the point of view of external clients?
- barrkel 9y agoBlocking is not normally equivalent to termination for most processes, and not all database activity is from human interaction.