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.

Regular expressions unleashed in PostgreSQL

by Hans-Jürgen Schönig | 04.2014
How to use an operator to work with regular expressions in PostgreSQL: includes list and a case-sensitive example. Fun with coding PostgreSQL

Bypassing the transaction log

by Hans-Jürgen Schönig | 04.2014
When data is changed generally the change must be written to the xlog before it is written to the underlying table.

Detecting fraud: Benford's law

by Hans-Jürgen Schönig | 01.2014
Benford's law is a mechanism, which is widely used in many fields. Especially accounting fraud can be detected nicely using this simple law of mathematics.

Fed up with long WHERE-clauses?

by Hans-Jürgen Schönig | 12.2013
What if you want to compare dozens of columns with each other in PostgreSQL? Find out how to do it right here.

PostgreSQL shutdown modes

by Hans-Jürgen Schönig | 12.2013
PostgreSQL has three shutdown modes - smart, fast, immediate. Check out this blogpost to learn more about all of them.

Tracking changes in PostgreSQL

by Hans-Jürgen Schönig | 12.2013
UPDATED 2023 - How to track changes made to tables in PostgreSQL - instructions how to use a generic changelog trigger for tracking changes.

Making random() deterministic - random generator in PostgreSQL

by Hans-Jürgen Schönig | 12.2013
How to reproduce a random sequence of numbers. Reset the random generator to restart a certain value in PostgreSQL. random()

PostgreSQL: Finding Christmas presents

by Hans-Jürgen Schönig | 12.2013
In this blog we are talking about KNN-search. KNN-search has been made for finding something close to what you are looking for.

effective_cache_size: Better set it right

by Hans-Jürgen Schönig | 11.2013
effective_cache_size can have a serious impact on execution plans and change things dramatically. See what kind of difference it can make.

Operator classes explained

by Hans-Jürgen Schönig | 11.2013
In this blog we are tallking about the topic operator class. We will show you some strategies for your database.
1 … 30 31 32 33 34 35
CYBERTEC Logo white
STAY TUNED WITH OUR NEWSLETTER
Get the newest PostgreSQL Info & Tools


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

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