Re: HASH index method not correctly handling NULL text
От | Neil Conway |
---|---|
Тема | Re: HASH index method not correctly handling NULL text |
Дата | |
Msg-id | 1012699402.17741.39.camel@jiro обсуждение исходный текст |
Ответ на | Re: HASH index method not correctly handling NULL text values? (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: HASH index method not correctly handling NULL text
|
Список | pgsql-general |
On Sat, 2002-02-02 at 19:58, Tom Lane wrote: > David Madore <david.madore@ens.fr> writes: > > table has 345442 rows, of which 344339 have a non NULL value in the > > column in question. The index creation proceeded without trouble, but > > a subsequent "VACUUM VERBOSE ANALYZE" command gave the following > > warning: "NUMBER OF INDEX' TUPLES (344339) IS NOT THE SAME AS HEAP' > > (345442)" with the advice to recreate the index. Essentially, my > > question is: is the warning incorrect or is the index so? > > The warning should be suppressed for hash indexes, since they don't > include nulls. I believe this is fixed in 7.2. Is there a reason why hash indexes don't include NULLs? Cheers, Neil -- Neil Conway <neilconway@rogers.com> PGP Key ID: DB3C29FC
В списке pgsql-general по дате отправления: