planet.postgresql.org

Paul Ramsey: OGR FDW Spatial Filtering

The OGR FDW now pushes spatial filters down to remote data sources! Whuuuut?!?!? The Basics OK, first, “OGR” is a subcomponent of the GDAL toolkit that allows generic access to dozens of different geospatial file formats. The OGR part handles the “vector” data (points, lines and polygons) and the GDAL part handles the “raster” data (imagery, elevation grids). Second, “FDW” is a...

planet.postgresql.org

Craig Kerstiens: An interview on what makes Postgres unique (extensions)

I’ve been at dinners before with developers that admitted developers, themselves included, can be a bit opinionated. In one case one said for example, “I love Postgres, but I have no idea why.” They were sitting at the wrong table to use Postgres as an example… But it is quite often that I am asked Why Postgres. In fact a little over a year ago good friend Dimitri Fontaine asked if he...

planet.postgresql.org

Colin Charles: Database Tab Sweep

I miss a proper database related newsletter for busy people. There’s so much happening in the space, from tech, to licensing, and even usage. Anyway, quick tab sweep. Paul Vallée (of Pythian fame) has been working on Tehama for sometime, and now he gets to do it full time as a PE firm, bought control of Pythian’s services business. Pythian has more than 350 employees, and 250 customers, and...

planet.postgresql.org

damien clochard: Achieving k-anonymity with PostgreSQL

Dalibo Labs just released yesterday the version 0.5 of PostgreSQL Anonymizer, an extension that hides sensitive information inside a PostgreSQL database. The extension already has a large panel of anonymization strategies: randomization, faking, partial destruction, shuffling, noise addition, etc. For this new released, I worked on a different approach called Generalization and the k-anonymity...

planet.postgresql.org

Richard Yen: Making Mystery-Solving Easier with auto_explain

Introduction I recently had to work on a case where a customer noticed some poor application performance after migrating from Oracle to PostgreSQL. They seemed to have tried everything in the playbook, but the problem simply wouldn’t get any better. They tried tuning autovacuum (but the tables weren’t bloated), tried tuning shared_buffers (but EXPLAIN ANALYZE wasn’t showing stuff getting...

planet.postgresql.org

Luca Ferrari: PostgreSQL 12 package on FreeBSD

PostgreSQL 12 is available as binary package on FreeBSD, but not in the quarterly update. PostgreSQL 12 package on FreeBSD In the case you need to install PostgreSQL 12 on FreeBSD please consider it has not reached the quarterly pkg(1) update, therefore if you install it via pkg(1) you will get PostgreSQL 12 rc1. However, in the ports tree, PostgreSQL is clearly at version 12 (release). This...

planet.postgresql.org

Luca Ferrari: PostgreSQL 12 Generated Columns

PostgreSQL 12 provides support for automatically computed columns. PostgreSQL 12 Generated Columns PostgreSQL 12 introduces the generated columns, columns that are automatically computed depending on a generation expression. The usage of generated columns is quite simple and can be summarized as follows: the column must be annotated with the GENERATED ALWAYS AS (...) STORED instruction; the...

planet.postgresql.org

Luca Ferrari: Installing PostgreSQL on FreeBSD via Ansible

My very simple attempt at keeping PostgreSQL up-to-date on FreeBSD machines. Installing PostgreSQL on FreeBSD via Ansible I’m slowly moving to Ansible to manage my machines, and one problem I’m trying to solve at best is how to keep PostgreSQL up-to-date. In the case of FreeBSD machines, pkgng is the module to use, but in the past I was used to this very simple playbook snippet: - name:...

planet.postgresql.org

Craig Kerstiens: Interesting Upcoming pgDays

I’ve been to a lot of conferences over the years. PgConf EU, PostgresOpen, too many pgDays to count, and even more none Postgres conferences (OSCON, Strangeloop, Railsconf, PyCon, LessConf, and many more). I’ve always found Postgres conferences one of the best places to get training and learn about what’s new with Postgres (in addition to Dimitri’s recent book, more on that below)....