Tom Lane wrote:
Pieter-Jan Savat <[EMAIL PROTECTED]> writes:
2005-10-11 17:22:28 CEST ([EMAIL PROTECTED]) [2005-10-11 17:08:49 CEST]
PANIC: right sibling's left-link doesn't match
You've got a corrupt btree index. Try reindexing that table.
Tom Lane wrote:
That shouldn't happen. What shows up in the postmaster log?
Here is the output of the log:
2005-10-11 17:22:00 CEST (@) [] DEBUG: checkpoint complete; 0
transaction log file(s) added, 0 removed, 3 recycled
2005-10-11 17:22:26 CEST (@) [] LOG: checkpoints are occurring to
Hi,
I'm performing some tests on performance: when to use or not use foreign
keys.
I have a table A with 50 columns, 8 of them have a foreign key to some
other table,
and there is a table B with 65 columns, only 5 of them have a foreign
key to some table (so foreign data is copied locally).
Th
Hello,
I'm facing the following problem.
I have a postgres 8.0 DB with a table 'results' containing 6.000.000
records.
This table has 16 indexes. Each one basically created to speed up
different queries.
Because of some glitch in the system there has never been a VACUUM FULL
on this table.
