Tag Results

In a March blog post I talked about the mismatch between what people expect from Postgres in terms of hints, and what exists. In this blog post I would like to cover the more general case of when people should expect feature parity with their previous database, and when such expectations are unreasonable. First, imagine if every database had the features of every other database — that would be great for compatibility but terrible for usability. You would have so many ways of […]

While designing a database system most of the time you have to pick a compromise between availability, durability, performance and cost. Most of the time system design prefers being fast by default, thereby leaving a question about its durability need. Postgres community has a different approach to this problem. Postgres does have several options that can be used for performance gains while maintaining the durability aspect. A combination of Postgres features like synchronous replication and EDB’s Failover Manager is one of […]

The list of new features coming in PostgreSQL 10 is extremely impressive.  I’ve been involved in the PostgreSQL project since the 8.4 release cycle (2008-2009), and I’ve never seen anything like this.  Many people have already blogged about these features elsewhere; my purpose here is just to bring together a list of the features that, in my opinion, are the biggest new things that we can expect to see in PostgreSQL 10. [Disclaimers: (1) Other people may have different opinions.  (2) […]

Postgres Vision 2016 last October in San Francisco was a great platform for open source data management for the businesses, the community: Technology & Roadmap, the developers and the ecosystem. Its again time for the conference in 2017. Ashnik is once again pleased to be Silver Sponsor at the Postgres Vision 2017, the preeminent event of thought leadership, collaboration and networking with the best and the brightest companies defining the future of enterprise Postgres and open source data management. The theme will revolve around “Digital […]

For the last few weeks, I have been working with a key opportunity of Ashnik – a major Bank in Singapore, on designing a database solution for them. The solution will be based on EDB Postgres and will support one of the key applications for the bank. It can be considered as one of the most ambitious implementations of Postgres in the BFSI segment. On meeting their team for the first time, I realized that the bank is a mature user […]