Tom,
> One question that comes to mind is were you reindexing a system or user
> table?
User.
> Another is whether you were using disks that lie about write
> completion (SCSI vs IDE)?
First thing I thought of. Haven't been able to verify, yet.
The basic symptoms are:
1) Machine stated scheduled REINDEX.
2) Unexpected power-out
3) On reboot, we have 2 different versions of the index file on disk,
one with 0 bytes. Attempts to use the index (via SELECT) result in
statement-fatal errors.
I'm waiting on more data. For now, I was wondering whether there was a known
issue with WAL recovery on indexes in 7.2.4. Neil thought there was.
--
-Josh Berkus
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology [EMAIL PROTECTED]
and data management solutions (415) 565-7293
for law firms, small businesses fax 651-9224
and non-profit organizations. San Francisco
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
