Re: Indexes on RAM disk = insanity?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Steve Lane <slane(at)soliantconsulting(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Indexes on RAM disk = insanity?
Date: 2005-07-29 16:21:02
Message-ID: 2612.1122654062@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Steve Lane <slane(at)soliantconsulting(dot)com> writes:
> Or will postgres 8 rebuild an index if it doesn't find it where it expects?

No, but there's always REINDEX.

> I recognize, or think I do, that PG 8 tablespaces would be required to
> accomplish this.

It'd certainly make it a lot easier. Also, it's probably not worth the
pain to try to move system catalog indexes to RAMdisk --- that'll
greatly complicate the restart process. User-table indexes could be
fixed just with REINDEX.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Fabio C. Bon 2005-07-29 16:30:46 Questions about fsync
Previous Message Richard_D_Levine 2005-07-29 15:57:46 Re: Indexes on RAM disk = insanity?