Tag Results

As we approach year end, our EDB team was inspired to take a look back at our blog posts from the year and see what topics resonated the most with our readers. Here is a Top 10 recap of your favorites from 2017. 10. Pgpool II Keeps Pace With Demands of Today’s Architectures and Workloads This blog is about Pgpool II, the middleware product that sits between the PostgreSQL server and database clients. Coming in at #10 for 2017, our readers […]

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 […]

Streaming replication in PostgreSQL can be asynchronous or synchronous. The synchronous option provides greater data protection in case of disaster, or if a server or data center goes down. Synchronous replication does come with a performance penalty, which is why many people use the default asynchronous option if losing some data in case of disaster is not a big issue. For any application such as a financial application that cannot tolerate any data loss, synchronous replication is the answer. Synchronous replication […]

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 […]

As more and more enterprise in SEA are embarking on their digital transformation journey, Ashnik has aligned services and offerings to meet its customers’ digital transformation initiatives. Open source technologies are the key drivers of this initiative as they address cost optimization and agility factors.  We are excited to take this to the next level by creating a framework putting together our experience in open source consulting, services and solutions. With key open source technology partners, especially EnterpriseDB (EDB), Ashnik has successfully […]

The data center has become a center of great complexity. Data has proliferated with more devices, greater volumes, and higher velocities. In trying to extract greater value (i.e. actionable intelligence) from data, many IT managers deployed a host of new solutions to manage, store, and analyze data. Specialized solutions, such as NoSQL data stores like MongoDB, Hadoop, and Cassandra, have become go-to databases because they can meet specific needs for some companies. But they also can be problematic and burdensome for […]

Ashnik recently brought EDB certified PostgreSQL training to Singapore for PostgreSQL DBAs and aspiring DBAs, Application Developers – designed by our panel of experienced DBAs – with expertise in Customer Implementation, Tuning, Health check, Oracle migration, HA and DR setups. – EDB Certified Comprehensive PostgreSQL Training(5 Days) – Foundation of PostgreSQL Administration(3 Days) Dates: 12th – 16th December 2016 Feedback from our trainees is of paramount importance to make every future training better and ensuring it caters to your needs effectively. Hear what our trainees […]

The three-year return on investment of the EDB Postgres™ Platform is 168%, according to a new white paper on the comprehensive business impact of EDB Postgres based on interviews with EDB customers. The white paper titled The Economic and Business Advantages of EDB Postgres Database Solutions*, developed by International Data Corp (IDC), a leading IT market research and advisory firm. The white paper describes how EDB Postgres Platform customers are well positioned for meeting expanding business demands, while reducing costs across the […]

The world is experiencing the greatest information explosion in history: — 90% of the world’s data was created in the last five years, and most of it is unstructured. The volume, velocity, and variety of data are unprecedented. — Gartner says by 2020, 25 billion connected things will be generating data 24x7x365. This incredible expansion in the volume, velocity, and variety of data is the engine driving the torrid pace of innovation that we experience today. Companies everywhere strive to understand […]

Recently, I have come across numerous situations where-in the organizations were considering to move from proprietary RDBMS system to Postgres. While they are willing to move to open source databases, they  are  sceptical whether PostgreSQL will be able to meet their specific requirements which are currently being taken care of by their existing proprietary RDBMS database. On my journey from Oracle to Postgres, I have noticed the immense enthusiasm in the Postgres community worldwide to help organization relalise the benefits of open source. I will […]