Skip site navigation (1) Skip section navigation (2)

Re: Slow functional indexes?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stuart Bishop <stuart(dot)bishop(at)canonical(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow functional indexes?
Date: 2006-10-21 03:30:32
Message-ID: 20906.1161401432@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Stuart Bishop <stuart(dot)bishop(at)canonical(dot)com> writes:
> I would like to understand what causes some of my indexes to be slower to
> use than others with PostgreSQL 8.1.

I was about to opine that it was all about different levels of
correlation between the index order and physical table order ... but
your experiments with freshly clustered indexes seem to cast doubt
on that idea.  Are you sure your function is really immutable?  A buggy
function could possibly lead to a "clustered" index not being in
physical order.

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Joshua D. DrakeDate: 2006-10-21 03:39:17
Subject: Re: Is ODBC that slow?
Previous:From: Merlin MoncureDate: 2006-10-21 02:50:01
Subject: Re: Is ODBC that slow?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group