Category: How To

Get the Newest PostgreSQL Info, Tips & Tricks

Here you can find all blog posts about the Category: How To. You can go back to all blog posts or take a look into our other categories & tags.

Reducing space consumption

by Hans-Jürgen Schönig | 10.2013

After digging through some customer source code yesterday I thought that it might be worth publishing a post about space consumption and enum types. It seems to be quite common to store status information as text fields. This is highly inefficient.

How To

CREATE DOMAIN: Data type abstraction

by Hans-Jürgen Schönig | 10.2013

In a procedural language such as C people will create typedefs & functions But what about data type abstraction in SQL?

How To

Changing histogram sizes

by Hans-Jürgen Schönig | 10.2013

Statistics are the rocket fuel behind performance. Learn to adjust histogram sizes for optimal performance results.

How To

Reducing the impact of locking

by Hans-Jürgen Schönig | 10.2013

(Bad) locking and low concurrency lead to poor performance results. Learn to minimize locking in PostgreSQL.

How To

Per-tablespace storage parameters

by Hans-Jürgen Schönig | 10.2013

A per-tablespace can be used to add more hardware to the system – but, is there some other way to make use of a tablespace? There is!

How To

Sequences – transactional behavior

by Hans-Jürgen Schönig | 09.2013

Creating and using sequences in PostgreSQL - Database sequences are database objects from which multiple users can generate unique numbers.

How To

Import stock market data into PostgreSQL

by Hans-Jürgen Schönig | 09.2013

The internet is full of people who want to import stock market data into a database. How can data be imported into PostgreSQL nicely?

How To

Storing network information

by Hans-Jürgen Schönig | 09.2013

PostgreSQL can handle IP addresses - and network information in general - pretty nicely. Check out this blogpost to learn more.

How To

Monitoring: Keeping an eye on old transactions

by Hans-Jürgen Schönig | 09.2013

To handle transactions PostgreSQL uses a mechanism called MVCC (Multi Version Concurrency Control). The core idea of this machinery is to allow the storage engine to keep more than just one version of the row.

How To