Re: pg_trgm indexes giving bad estimations?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ben <bench(at)silentmedia(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: pg_trgm indexes giving bad estimations?
Date: 2006-11-01 06:01:17
Message-ID: 13752.1162360877@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Ben <bench(at)silentmedia(dot)com> writes:
> Unfortunately, it's not at all clear to me from reading
> http://www.postgresql.org/docs/8.1/interactive/xoper-optimization.html#AEN33077
> how like impliments selectivity. Any pointers on where to look?

likesel() and subsidiary functions in src/backend/utils/adt/selfuncs.c

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Andreas Kostyrka 2006-11-01 09:21:01 Re: big transaction slows down over time - but disk
Previous Message Ben 2006-11-01 05:58:36 big transaction slows down over time - but disk seems almost unused