Re: [HACKERS] Constraint exclusion, some questions

2005-09-29 Thread Hannu Krosing
On N, 2005-09-29 at 11:24 +0200, [EMAIL PROTECTED] wrote: > Hi, I'm testing constraint exclusion on PostgreSQL 8.1 beta 1 on windows with > the GEOIP countries database and I have a few questions: > > 1. Can I say that an index created on the "parent" table is a "global" index, > an index that spa

[HACKERS] Constraint exclusion, some questions

2005-09-29 Thread pmagnoli
Hi, I'm testing constraint exclusion on PostgreSQL 8.1 beta 1 on windows with the GEOIP countries database and I have a few questions: 1. Can I say that an index created on the "parent" table is a "global" index, an index that spans over data in all derived tables? 2. Can I say that an index creat