PostgreSQL: Detecting periods of activity in a timeseries
PostgreSQL is a nice tool to handle activity in a timeseries. One of the more challenging tasks is to detect periods of constant activity.
CREATE VIEW vs ALTER TABLE in PostgreSQL
A view is a virtual table based on a SQL statement. What happens if the data structure of the underlying PostgreSQL table changes?
Mapping Oracle datatypes to PostgreSQL
How to map Oracle datatypes to PostgreSQL in the best way - this post helps you by making your migration to PostgreSQL as simple as possible.
Building PostgreSQL with MSYS2 and MinGW under Windows
In this blog you will learn how to build PostgreSQL from sources under Windows using MSYS2 and MinGW-64 in easy steps.
PostgreSQL: Sharing data across function calls
Recently I did some PostgreSQL consulting in the Berlin area (Germany) when I stumbled over an interesting request: How can […]
ora_migrator: migration from Oracle to PostgreSQL
ora_migrator is a migration tool, which makes migration as simple as possible: It only takes a single SQL statement to migrate a database.
xmax is a PostgreSQL system column that is used to implement Multiversion Concurrency Control (MVCC). The documentation is somewhat terse: […]
idle_in_transaction_session_timeout: Terminating idle transactions in PostgreSQL
Long PostgreSQL transactions can cause table bloat. idle_in_transaction_session_timeout limits the duration of a transaction to prevent bloat
Window function: Why first_value and last_value are not bugs
PostgreSQL can be used for more than just trivial queries. A look into what a window function does: first_value and last_value in PostgreSQL.
PostgreSQL: Speeding up analytics and window functions
How to improve speed is by rearranging window functions in a clever way: some clever optimization can give you better database performance.
