July 3rd, 2011 by depesz | Tags: configuration, gin, guc, postgresql, understanding, work_mem | 8 comments »
For todays post in Understanding postgresql.conf series, I chose work_mem parameter.
February 19th, 2011 by depesz | Tags: gin, ilike, like, performance, pg91, pg_trgm, postgresql | 5 comments »
On 1st of February, Tom Lane committed patch: Support LIKE and ILIKE index searches via contrib/pg_trgm indexes. Unlike Btree-based LIKE optimization, this works for non-left-anchored search patterns. The effectiveness of the search depends on how many trigrams can be extracted from the pattern. ...
May 17th, 2008 by depesz | Tags: gin, pg84, postgresql, prefix, sequence, truncate, tsearch | 1 comment »
Today we have two interesting patches: patch by Teodor Sigaev and Oleg Bartunov, and committed by Tom Lane, which adds interesting capability to GIN indexes patch by Zoltan Boszormenyi, also committed by Tom, which adds "RESTART" option to ALTER SEQUENCE. With some ...
