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