From: A J <s5aly@yahoo.com>
To: PG Admin <pgsql-admin@postgresql.org>
Subject: How to remove index from memory ?
Date: Fri, 12 Aug 2011 06:39:32 -0700 (PDT)
Message-ID: <1313156372.66476.YahooMailNeo@web120002.mail.ne1.yahoo.com> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: s5aly@yahoo.com
Subject: Re: How to remove index from memory ?
In-Reply-To: <1313156372.66476.YahooMailNeo@web120002.mail.ne1.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox