CYBERTEC PostgreSQL Logo

Tag: index

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

PostgreSQL: Indexes and foreign keys

by Hans-Jürgen Schönig | 07.2017
Missing indexes and foreign keys may cause database performance problems. Learn how to speed up things dramatically - not only in PostgreSQL!

Trying out Postgres Bloom indexes

by CYBERTEC Guest | 12.2016
Let's set up a simple demo to exemplify “fields of application” for Bloom and to also gauge pros/cons/performance in comparison to B-tree.

So what are Bloom indexes for Postgres?

by CYBERTEC Guest | 12.2016
Overview of the Bloom index in PostgreSQL. It's a very useful index method - find out how to use it & how it affects performance.

BRIN indexes: Correlation, correlation, correlation

by Hans-Jürgen Schönig | 06.2016
BRIN indexes have been introduced in PostgreSQL 9.5. While BRIN indexes are definitely a win, people tend to exaggerate and use them far too frequently.

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.

Killing proper indexing: A neat idea

by Hans-Jürgen Schönig | 10.2014
There are a couple of ways to kill indexing entirely. One of this ways is to apply functions or expressions. Read out in our blog.

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.

Speeding up “min” and “max”

by Hans-Jürgen Schönig | 09.2013
In this blog you can read why indexes are a great tool. And how it is possible speeding up a query many times by avoiding a sequential scans,
1 2 3
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