CYBERTEC PostgreSQL Logo

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.

Using regular expressions and arrays in PostgreSQL

by Hans-Jürgen Schönig | 06.2025
Learn how to combine the usage of regular expressions and arrays in PostgreSQL into a more powerful technology through this blog post.

The Fun of Open Source: Roman Numerals in PostgreSQL

by Laurenz Albe | 06.2025
© Laurenz Albe 2025 Recently, I wrote about the power of open source. Now, power is good and important, but […]

Meet the CYBERTEC Migrator

by Kieran Kaelin | 05.2025
Migrate to PostgreSQL fast, furious, and FREE: get the CYBERTEC Migrator Standard Edition, the fastest free migration tool!

When The Dead Won't Die

by Bernd Helmle | 05.2025
How do PostgreSQL's VACUUM optimizations affect dead tuple metrics? Find out why they might persist or reappear when using VACUUM.

CREATE INDEX: Data types matter

by Hans-Jürgen Schönig | 05.2025
Data types play a crucial role in ensuring optimal performance, efficiency, as well as semantics. Read more about CREATE INDEX.

PostgreSQL Trusted Extensions for Beginners

by Pavlo Golub | 04.2025
Especially beginners are often having problems concerning the concept of Trusted Extensions. Let's fix that!

Orphaned files after a PostgreSQL crash

by Laurenz Albe | 04.2025
This article describes how a PostgreSQL crash can leave some orphaned files behind and what you can do to get rid of them.

Type alignment and padding bytes: how to not waste space in PostgreSQL tables

by Laurenz Albe | 04.2025
Learn the concepts of data type alignment and padding bytes in PostgreSQL and how to define your table so that you don't waste storage space.

Indexing vectors in PostgreSQL

by Hans-Jürgen Schönig | 04.2025
Efficiency is always a topic. Therefore, it is important to understand that indexing is the key to success. Read more about indexing vectors.

pgai: Importing Wikipedia into PostgreSQL

by Hans-Jürgen Schönig | 04.2025
In this blog posting you can read more about how we can import Wikipedia into PostgreSQL and make use of it by using pgai.
1 2 3 37
CYBERTEC Logo white
Get the newest PostgreSQL Info & Tools


    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    ©
    2025
    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram