Some time ago I wrote a blogpost about why index might not be used. While this post seemed to be well received (top link from depesz.com on reddit), it doesn't answer another question - what index to create for given situation. I'll ...
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. ...
On 29th of December, Robert Haas committed interesting patch, which does: Support unlogged tables. The contents of an unlogged table aren't WAL-logged; thus, they are not available on standby servers and are truncated whenever the database system enters recovery. Indexes on unlogged tables ...
On 4th of December, Tom Lane committed really cool patch: KNNGIST, otherwise known as order-by-operator support for GIST. This commit represents a rather heavily editorialized version of Teodor's builtin_knngist_itself-0.8.2 and builtin_knngist_proc-0.8.1 patches. I redid the opclass API to add a separate Distance method instead ...
Starting new blog series - explanation of various configuration parameters. I will of course follow no schedule or order - if I'd had to - it would be my job, and in this way - it's fun. First configuration parameter to write ...
Before I'll start let me say that I am fan of what Oleg and Teodor did - their work is great, and I do appreciate their time and ideas. But - I simply don't like the idea of using FTS (Full ...
Foreign keys are known for couple of things, but speeding up your system is not one of them. But sometimes, having them in place lets you make queries significantly faster. How? Let me show you example I have seen lately (well, ...
Today, Mattias|farm on IRC asked how to create primary key using HASH index. After some talk, he said that in some books it said that for "=" (equality) hash indexes are better. So, I digged a bit deeper.
One database that I am monitoring uses a lot of stored procedures. Some of them are fast, some of them are not so fast. I thought - is there a sensible way to diagnose which part of stored procedure take ...
On 3rd of August, Tatsuo Ishii committed patch by ITAGAKI Takahiro: Log Message: ----------- Multi-threaded version of pgbench contributed by ITAGAKI Takahiro, reviewed by Greg Smith and Josh Williams. Following is the proposal from ITAGAKI Takahiro: Pgbench is a famous tool to measure postgres performance, but ...
