pgsql_tweaks is a bundle of functions and views for PostgreSQL

The source code is available on Codeberg.
You can install the whole package, or just copy what is needed from the source code.

The extension is also available on PGXN.

Version 1.0

I decided to make this the 1.0 Version. The First commit is from 2017-08-11, the extension is now more than eight years old.

News

The project started as a personal repository. When I left GitHub, see Leaving GitHub and GitHub is History for details, I decided to move it to a project on its own on Codeberg.

Website

The website on pgsql-tweaks.org has been setup first with the HTML help page of the project.

Now it is a real website realised with Jekyll. Future changes of pgsql_tweaks will be blogged on pgsql-tweaks.org/blog.
The source code is part of the project on Codeberg.

Also the documentation has been changed from a single Markdown file to a website, also realised with Jekyll on rtfm.pgsql-tweaks.org. RTFM stands for Read The Fine Manual.
The source code is part of the project on Codeberg.

Contribution

This move also opens the possibilities to contribute to the project. The documentation has now detailed information about how to contribute:

• Contribution Informaion
• Developer Informaion

Extension Changes

pgsql_tweaks Becomes a Logo

Thanks to Elodie Jex the extension has a shiny logo.


Created in Schema pgsql_tweaks

Instead of the current default schema, the extension is now created in its own schema. This solves conflicts with other extensions, as has been the case in the past with pgtap, see pgTAP Issue 340 for details.

Documentation for View pg_unused_indexes

The view has not been documented in previous versions.

New Features

The new features are blogged on pgsql_tweaks Version 1 Released!.

Author: Stefanie Janine Stölting