Re: [ADMIN] indexes separate from data

2002-04-03 Thread Marin Dimitrov
- Original Message - From: "Jean-Luc Lachance" > Interesting... What happens when you drop and recreate the index??? > repeat the whole procedure again hth, Marin "...what you brought from your past, is of no use in your present. When you must choose a new path, do no

Re: [ADMIN] indexes separate from data

2002-04-03 Thread Jean-Luc Lachance
Interesting... What happens when you drop and recreate the index??? Marin Dimitrov wrote: > > - Original Message - > From: "Judy Jecelin" > > > > > Hi, > > > > A relatively novice user of PostgreSQL but not > > of other databases... I'm trying to understand the > > use of initlocation.

Re: [ADMIN] indexes separate from data

2002-04-02 Thread Marin Dimitrov
- Original Message - From: "Judy Jecelin" > > Hi, > > A relatively novice user of PostgreSQL but not > of other databases... I'm trying to understand the > use of initlocationI understand having separate > data storage areas (perhaps for each database > in your postmaster), but is th

[ADMIN] indexes separate from data

2002-04-02 Thread Judy Jecelin
Hi, A relatively novice user of PostgreSQL but not of other databases... I'm trying to understand the use of initlocationI understand having separate data storage areas (perhaps for each database in your postmaster), but is there some way to have a separate location for indexes? How would