Re: Why no performance boost although I added an index?

From: nolan(at)celery(dot)tssi(dot)com
To: pgsql-general(at)postgresql(dot)org (pgsql general list)
Subject: Re: Why no performance boost although I added an index?
Date: 2003-04-07 23:05:04
Message-ID: 20030407230504.22084.qmail@celery.tssi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> This is a really big lose if your index and table are on the same disk.

That implies there is an easy way to ensure that the index and table
aren't on the same disk. That's not obvious from the documentation.

Maybe I just don't understand which subdirectories the data and index are
kept in?
--
Mike Nolan

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-04-08 00:02:07 Re: Backpatch FK changes to 7.3 and 7.2?
Previous Message Dan Langille 2003-04-07 22:24:09 Re: Why no performance boost although I added an index?