Re: Why no performance boost although I added an index? - Mailing list pgsql-general

From nolan@celery.tssi.com
Subject Re: Why no performance boost although I added an index?
Date
Msg-id 20030407230504.22084.qmail@celery.tssi.com
Whole thread Raw
In response to Why no performance boost although I added an index?  (Holger Marzen <holger@marzen.de>)
List 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


pgsql-general by date:

Previous
From: "Dan Langille"
Date:
Subject: Re: Why no performance boost although I added an index?
Next
From: Tom Lane
Date:
Subject: Re: Backpatch FK changes to 7.3 and 7.2?