X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 5F317474E5C for ; Wed, 12 Feb 2003 06:52:07 -0500 (EST) Received: from grunt23.ihug.com.au (grunt23.ihug.com.au [203.109.249.143]) by postgresql.org (Postfix) with ESMTP id BB513474E44 for ; Wed, 12 Feb 2003 06:52:06 -0500 (EST) Received: from p455-tnt1.mel.ihug.com.au (postgresql.org) [203.173.161.201] by grunt23.ihug.com.au with esmtp (Exim 3.35 #1 (Debian)) id 18ivQl-00079e-00; Wed, 12 Feb 2003 22:51:59 +1100 Message-ID: <3E4A355C.1040109@postgresql.org> Date: Wed, 12 Feb 2003 22:51:56 +1100 From: Justin Clift User-Agent: Mozilla/5.0 (Windows; U; WinNT4.0; en-US; rv:1.2.1) Gecko/20021130 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Bruce Momjian Cc: Josh Berkus , philip johnson , pgsql-performance@postgresql.org Subject: Re: how to configure my new server References: <200302120552.h1C5q8B09618@candle.pha.pa.us> In-Reply-To: <200302120552.h1C5q8B09618@candle.pha.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/53 X-Sequence-Number: 1109 Bruce Momjian wrote: > Josh Berkus wrote: > >>>>how can I put indexes on a seperate disk ? >> >>Move the index object (use the oid2name package in /contrib to find the index) >>to a different location, and symlink it back to its original location. Make >>sure that you REINDEX at maintainence time, and don't drop and re-create the >>index, as that will have the effect of moving it back to the original >>location. > > I believe reindex will create a new file and hence remove the symlink, > at least in 7.3. Yep, it's a complete pain. You can't stabily have indexes moved to different drives, or even different partitions on the same drive (i.e. fastest disk area), as they're recreated in the default data location at index time. This was one of the things I was hoping would _somehow_ be solved with namespaces, as in high transaction volume environments it would be nice to have frequently used indexes [be practical] on separate drives from the data. At present, that's not very workable. Regards and best wishes, Justin Clift -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi