Re: Estimation problem with a LIKE clause containing a /

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Estimation problem with a LIKE clause containing a /
Date: 2007-11-08 15:01:09
Message-ID: 24220.1194534069@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

"Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com> writes:
> On Nov 8, 2007 12:14 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> I've applied a patch that might help you:
>> http://archives.postgresql.org/pgsql-committers/2007-11/msg00104.php

> AFAICS, it doesn't seem to fix the problem.

Hmm, can we see the pg_stats row for the ancestors column?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-11-08 15:07:41 Re: minimal update
Previous Message Tom Lane 2007-11-08 14:58:49 Re: A small rant about coding style for backend functions

Browse pgsql-performance by date

  From Date Subject
Next Message Heikki Linnakangas 2007-11-08 15:09:55 Re: Need to run CLUSTER to keep performance
Previous Message Alvaro Herrera 2007-11-08 14:56:46 Re: Need to run CLUSTER to keep performance