Re: [HACKERS] Estimation problem with a LIKE clause containing a /

From: "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Gregory Stark" <stark(at)enterprisedb(dot)com>, pgsql-performance <pgsql-performance(at)postgresql(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Estimation problem with a LIKE clause containing a /
Date: 2007-11-09 16:39:51
Message-ID: 1d4e0c10711090839v288a0614j174bdceadfc6b5b2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

On Nov 9, 2007 5:33 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> he's got no MCVs, presumably because the field
> is unique.

It is. The ancestors field contains the current folder itself so the
id of the folder (which is the primary key) is in it.

--
Guillaume

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-11-09 16:44:19 Re: New tzdata available
Previous Message Bruce Momjian 2007-11-09 16:39:03 Re: Fix for stop words in thesaurus file

Browse pgsql-performance by date

  From Date Subject
Next Message Claus Guttesen 2007-11-09 16:40:50 Re: dell versus hp
Previous Message Tom Lane 2007-11-09 16:33:45 Re: [HACKERS] Estimation problem with a LIKE clause containing a /