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.
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 […]
Tech preview: PostgreSQL 11 - CREATE PROCEDURE
With PostgreSQL 11 the new feature CREATE PROCEDURE has been initiated. This Blogpost is about how to use this PostgreSQL feature.
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.
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.
What PostgreSQL Full-Text-Search has to do with VACUUM
What does PostgreSQL Full-Text-Search have to do with VACUUM? Find out about the GIN pending list and how to use it to improve performance.
COPY in PostgreSQL: Moving data between servers
More than copy data between a file and a table: a pretty cool feature was added to PostgreSQL. You can send data directly to the UNIX pipe.
PostgreSQL performance: How the optimizer handles views
How does the PostgreSQL optimizer handle views? Are views good or bad? Write better and faster code, improve performance.