Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Estimation problem with a LIKE clause containing a / - Mailing list pgsql-performance

From Guillaume Smet
Subject Re: [HACKERS] Estimation problem with a LIKE clause containing a /
Date
Msg-id 1d4e0c10711090839v288a0614j174bdceadfc6b5b2@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Estimation problem with a LIKE clause containing a /  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
On Nov 9, 2007 5:33 PM, Tom Lane <tgl@sss.pgh.pa.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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Estimation problem with a LIKE clause containing a /
Next
From: "Claus Guttesen"
Date:
Subject: Re: dell versus hp