How to remove index from memory ?

From: A J <s5aly(at)yahoo(dot)com>
To: PG Admin <pgsql-admin(at)postgresql(dot)org>
Subject: How to remove index from memory ?
Date: 2011-08-12 13:39:32
Message-ID: 1313156372.66476.YahooMailNeo@web120002.mail.ne1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello
I am running a test to find the impact of corrupt indexes on queries. I corrupted the index file but observed that the queries continued to perform without issues. It was only on restart of the database that postgres realized that the indexes are corrupt and my queries started failing (with error like: ERROR:  invalid page header in block 0 of relation base/16384/16399)

My questions are:
1. How do I remove the indexes from memory ? I wish to stimulate the condition when indexes are no longer in database but the server has not restarted and see the effects of corrupt indexes.
2. Is there a more proactive and realtime way to detect corruption of indexes ?

Thanks for any inputs.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message CS DBA 2011-08-12 14:40:06 Re: replication from Oracle to PostgreSQL?
Previous Message Craig Ringer 2011-08-12 02:09:48 Re: replication from Oracle to PostgreSQL?