Vik Fearing

PostgreSQL Expert, EDB

Vik Fearing is a PostgreSQL expert at EDB, and lives in France. He has been in the PostgreSQL community since 2008 and is the founder and co-organizer of pgDay Paris, co-organizer of PostgreSQL Conference Europe, and a volunteer and speaker at many other conferences around the world. He is also a moderator for several of the PostgreSQL mailing lists as well as an IRC channel operator for #postgresql and #postgresqlfr. He is an inaugural member of the PostgreSQL Code of Conduct Committee and part of the team behind the @PostgreSQL Twitter account. In his spare time, he likes to write minor patches to the PostgreSQL codebase.

Read Blogs

Postgres Tutorials

PostgreSQL Performance Tuning: Optimize Your Database Server

Enhance your PostgreSQL database performance with EDB's expert tuning tips. Optimize queries, autovacuum, and more for a faster, more efficient database.
EDB Labs

Guide to ANY_VALUE() Functionality in PostgreSQL 16

The demand for effective and robust database management solutions has never been higher as businesses continue to produce and analyze enormous amounts of data.

The MERGE Command Has Finally Arrived in Postgres 15!

MERGE is the kind of thing we heard about for a long time before it was really implemented into PostgreSQL. According to Postgres wiki, the first time a contributor asked about this feature is as old as November 2005! We thought for a while we would see it in Postgres 14, but it was finally pushed back to Postgres 15.
Product Updates

Benchmarking PostgreSQL: Improving Performance Stability

Continuing my monthly PostgreSQL benchmarks series, these latest findings are aimed at helping developers improve PostgreSQL performance stability. I discovered the performance stability issue when I had to reset the AWS instance I used for the Daily 500 benchmarks and lost 20% performance. The only explanation I have is that the reset instance physically moved in the data center. From an ongoing...
EDB Labs

Benchmarking PostgreSQL: Setting up a RAID Array from Scratch

Vik Fearing reviews the results of a benchmarking effort of the PostgreSQL development branch with 500 concurrent users.
Product Updates

Benchmarking PostgreSQL: Overcoming an Unexpected Bottleneck

This blog continues conversations on benchmarking PostgreSQL with NOPM.
Product Updates

Benchmarking PostgreSQL with NOPM: The Daily 500 Users

Usually, benchmarks are measured in transactions per second, but the TPC-C and TPROC-C, benchmarks are measured in new orders per minute (NOPM). What is a new order? It’s simply a predefined operation on the database, that even fails 1% of the time. This is a better metric than transactions because you can have transactions on the database that are not part of the benchmark. Autoanalyze uses a...
Technical Blog

PostgreSQL TPROC-C Benchmarks: PostgreSQL 12 vs. PostgreSQL 13 Performance

PostgreSQL 13.0 was just released and included a number of performance improvements in various areas.