The EDB Blog

  1. Home
  2. The EDB Blog

Encryption Module in EDB Postgres Earns FIPS 140-2 Validation

4/6/2018
U.S. government agencies and other organizations that require higher levels of security now have another green light on the road to open source. The Cryptographic Module Validation Program (CMVP), operated by the National Institute of Standards and Technology (NIST), has awarded a coveted FIPS 140-...

More

Wal and Xlog

4/3/2018
Postgres isn't the best at naming things. Of course, there is the old computer saying, "There are only two hard things in Computer Science: cache invalidation and naming things." With Postgres being 31 years old and developed by several different project teams, naming can be even more inconsistent...

More

Containing Bloat with Partitions

3/27/2018
PGConf India 2018 attracted a large number of PostgreSQL users and developers. I talked about "query optimization techniques for partitioned tables" ( slides ). Last year, I had held an introductory talk about PostgreSQL's declarative partitioning support ( slides ). Many conference participants...

More

Zheap: A Storage Engine to Provide Better Control Over Bloat

3/20/2018
In the past few years, PostgreSQL has advanced a lot in terms of features, performance, and scalability for many core systems. However, one of the problems that many enterprises still complain is that its size increases over time which is commonly referred to as bloat. My colleague Robert Haas has...

More

Introduction to Parallel Sequential Scan

3/13/2018
In this video, we will have a look at how parallel sequential scan can be used in EDB Postgres Advanced Server to enhance the performance of the queries. Additionally, we will also have a look at the important parameters related to it, and discuss the scenarios where it does or does not boost the...

More

Making Postgres Talk to LDAP (with StartTLS)

2/27/2018
I recently got a few support cases from customers seeking to connect Postgres with LDAP (usually with some form of SSL/TLS encryption, to ensure security). I spent a bit of time trying to create a consistently reproducible environment where LDAP could be used to authenticate PostgreSQL connections...

More

Data in the Database vs. the File System

2/20/2018
An age-old question is whether it is better to put data in a database or a file system. Of course, the answer is "it depends," but let's look at what it depends on. First, Postgres stores its data in the file system, so the file system must be good for something. Postgres also stores some of its...

More

Untangling Years of Layered Legacy Systems

2/16/2018
Financial Services Institutions Look to Open Source Today’s financial services institutions must innovate and evolve their technology to remain competitive during a time of great disruption. The need for rapid innovation and increasing digitalization is shining a light on the IT complexity many...

More

BART 2.2 Sneak Peek

2/13/2018
The EDB Postgres Backup and Recovery Tool development team is super busy developing features for the next major release and I wanted to give everyone a sneak peek into the exciting new capabilities to be delivered as part of BART 2.2. The last major release of BART was published in June 2017 and we...

More

What is 256 Pages Long with 99 Articles, and Has Teeth?

2/12/2018
Explore How GDPR Impacts a DBA On May 25, 2018, the General Data Protection Regulation (GDPR) will take effect, and it will impact the way your organization collects and manages customer data in Europe. GDPR effectively replaces the data protection directive 9546EC, and is not just applicable to...

More

What Happens if You Don’t Monitor Your PostgreSQL Database Effectively?

2/6/2018
A good DBA is someone who knows how to monitor the databases EFFECTIVELY and when it comes to a production or business critical database, the job becomes even more crucial. ​Not monitoring your databases and system effectively may lead to a severe catastrophe - application slowness, database...

More

Plenty to Celebrate with Postgres the ‘DBMS of the Year’

2/1/2018
PostgreSQL has long been a popular database, loved by developers and database administrators for its ease of use, comprehensive and intuitive documentation , and reliability. Anyone at EnterpriseDB ® (EDB ™ ) could tell you that interest in PostgreSQL (also known as Postgres) has been growing...

More

DO or UNDO - There is no VACUUM

1/30/2018
What if PostgreSQL didn’t need VACUUM at all? This seems hard to imagine. After all, PostgreSQL uses multi-version concurrency control (MVCC), and if you create multiple versions of rows, you have to eventually get rid of the row versions somehow . In PostgreSQL, VACUUM is in charge of making sure...

More