Thread: REINDEX SYSTEM tables ... index disappearing ... ?
'k, I've been playing around with the REINDEX stuff, and either I'm mis-understanding something, or there is a bug in 7.4.x ... If I do a: REINDEX TABLE pg_statistic; my 'on disk' INDEX is disappearing, altho there is no errors being generated: # select oid,relname from pg_class where relname like 'pg_statistic%'; oid | relname -------+------------------------------ 16408 | pg_statistic 16647 | pg_statistic_relid_att_index (2 rows) But, on disk: $ ls -l 16408 16647 ls: 16647: No such file or directory -rw------- 1 pgsql pgsql 385024 Jun 13 15:28 16408 # reindex table pg_statistic; REINDEX # Shouldn't this work? Or, at least, generate an error message? ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
On 2005-06-13, "Marc G. Fournier" <scrappy@postgresql.org> wrote: > > 'k, I've been playing around with the REINDEX stuff, and either I'm > mis-understanding something, or there is a bug in 7.4.x ... > > If I do a: > > REINDEX TABLE pg_statistic; > > my 'on disk' INDEX is disappearing, altho there is no errors being > generated: > > # select oid,relname from pg_class where relname like 'pg_statistic%'; > oid | relname > -------+------------------------------ > 16408 | pg_statistic > 16647 | pg_statistic_relid_att_index > (2 rows) > > But, on disk: > > $ ls -l 16408 16647 > ls: 16647: No such file or directory The relfilenode of the index relation changes, so it's no longer equal to the OID. If you look on-disk for the relfilenode, you will find it. -- Andrew, Supernews http://www.supernews.com - individual and corporate NNTP services
On Mon, 13 Jun 2005, Andrew - Supernews wrote: > The relfilenode of the index relation changes, so it's no longer equal > to the OID. If you look on-disk for the relfilenode, you will find it. Perfect, hadn't even thought of that ... thanks ... ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664