CYBERTEC PostgreSQL Logo

Tag: development

Get the Newest PostgreSQL Info, Tips & Tricks
Here you can find all blog posts about the Tag: development. You can go back to all blog posts or take a look into our other categories & tags.

Flexible grouping: Some dirty SQL trickery

by Hans-Jürgen Schönig | 11.2015
How to group PostgreSQL data with some dirty SQL trickery. Find the difference between timestamps; how to use flexible grouping.

Indexing Wikipedia

by Hans-Jürgen Schönig | 10.2015
Indexing Wikipedia with PostgreSQL | The goal is to see which settings are most suitable for the creation of a GIN index.

Fuzzy search unleashed

by Hans-Jürgen Schönig | 08.2015
Fuzzy search solves the problem of spelling errors in searches. The goal is really to make sure that users have a chance - even with typos.

Partial aggregation: The beautiful way

by Hans-Jürgen Schönig | 02.2015
Partial aggregation: Functions such as min, max, count, sum, avg and so on are used in virtually every application. Find out more.

Forking databases - the art of copying without copying

by Ants Aasma | 01.2015
I received a question about how to fork PostgreSQL databases like you can do on Heroku. As I did not […]

Analytics: Lagging entire rows

by Hans-Jürgen Schönig | 10.2014
There is a PostgreSQL feature in the area of analytics which is not widely known: the power to use composite data types along with analytics.

Code size over time

by Hans-Jürgen Schönig | 08.2014
Out of plain curiosity I decided to start a little analysis regarding the code size of the PostgreSQL project over time.

Speed up PostgreSQL data loading with COPY (FREEZE)

by Hans-Jürgen Schönig | 08.2014
UPDATED JUL 2023 How to load data fast and efficiently in PostgreSQL using COPY (FREEZE). Organize data nicely by instantly writing hint bits.

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.
1 … 9 10 11 12 13
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.

    ©
    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