CYBERTEC 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.

Trying out Postgres Bloom indexes

by CYBERTEC Guest | 12.2016
By Kaarel Moppel - First - if the word “Bloom” doesn’t yet resonate with you in Postgres context, I’d recommend […]

So what are Bloom indexes for Postgres?

by CYBERTEC Guest | 12.2016
By Kaarel Moppel - A new feature called Bloom indexing (an implementation of Bloom filters) slipped in somewhat quietly with […]

BRIN indexes: Correlation, correlation, correlation

by Hans-Jürgen Schönig | 06.2016
Since BRIN indexes have been introduced in PostgreSQL 9.5, many people have gladly adopted this new index type. A lot […]

Indexing Wikipedia

by Hans-Jürgen Schönig | 10.2015
Wikipedia is one of the most relevant collections of text data on the Internet today. It consists of countless entries […]

Killing proper indexing: A neat idea

by Hans-Jürgen Schönig | 10.2014
After being on the road to do PostgreSQL consulting for CYBERTEC for over a decade I noticed that there are […]

Operator classes explained

by Hans-Jürgen Schönig | 11.2013
After my morning session in Dublin some people asked me to share the codes of an operator class I created […]

Speeding up “min” and “max”

by Hans-Jürgen Schönig | 09.2013
Indexes are a perfect tool to find a certain value or some kind of range in a table. It is […]

GIN - Just A Kind Of Index

by Hans-Jürgen Schönig | 03.2013
As far as PostgreSQL is concerned, GIN means an access method (index type) rather than a drink. The acronym stands […]
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf
Austria

+43 (0) 2622 93022-0
office@cybertec.at

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