Tag: Open Source

New versions of PgPool released – 3.1.3 & 3.0.7

This essential tool for Postgres architectures is continually improving, and is now available in its new releases. Both are bugfix versions. For those unfamiliar with the tool, it is a middleware with functionality as a load balancer, pooler*  and/or replication…

Read More >

Exploring a new feature of 9.2: Index-only scans

We, like other Postgres DBAs worldwide, have been waiting for the 9.2 release for some time, specifically for the index-only scan feature, which will help reduce I/O by preventing unnecessary access to heap data if you only need data from…

Read More >

Considerations about text searchs in big fields and planner costs

Imagine the following scenario: you have a table with a small set of records with columns containing tsvector and text data type. But, text fields has almost 20 megabytes of text or more. So, what happens? Postgres planner checks the…

Read More >

Indexing text columns with GIST or GIN to optimize LIKE, ILIKE using pg_trgm in Postgres 9.1 (Part 1)

“The pg_trgm module provides functions and operators for determining the similarity of ASCII alphanumeric text based on trigram matching, as well as index operator classes that support fast searching for similar strings.” This is the introduction to the official documentation…

Read More >
Page 2 of 212