pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Alternate disks for Indexes
2+ messages / 2 participants
[nested] [flat]

* Alternate disks for Indexes
@ 1998-10-26 13:23 pierre@desertmoon.com
  1998-10-26 13:52 ` RE: [SQL] Alternate disks for Indexes Shulyak AN <alec@nikts.nk.ukrtel.net>
  0 siblings, 1 reply; 2+ messages in thread

From: pierre@desertmoon.com @ 1998-10-26 13:23 UTC (permalink / raw)
  To: pgsql-sql



Here is a simple question. In oracle one can specify an alternate location
for indexes to live(i.e. a different disk) to help improve performance. Is
it possible to do so in Postgresql? Can I move the indexes then place a
link from the original location to an alternate disk location and have it
work?

Has anyone tried this?

-=pierre



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* RE: [SQL] Alternate disks for Indexes
  1998-10-26 13:23 Alternate disks for Indexes pierre@desertmoon.com
@ 1998-10-26 13:52 ` Shulyak AN <alec@nikts.nk.ukrtel.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Shulyak AN @ 1998-10-26 13:52 UTC (permalink / raw)
  To: pierre@desertmoon.com; +Cc: pgsql-sql


On 26-Oct-98 pierre@desertmoon.com wrote:
> 
> 
> Here is a simple question. In oracle one can specify an alternate location
> for indexes to live(i.e. a different disk) to help improve performance. Is
> it possible to do so in Postgresql? Can I move the indexes then place a
> link from the original location to an alternate disk location and have it
> work?
> 
> Has anyone tried this?
> 
> -=pierre

I did so with PostgreSQL 6.1 an do with 6.3.2. Fof unknown reasones
id didn't work with 6.2.


---
--------------------------------------------------------------------------
  Alexander N Shulyak  |   E-Mail: Shulyak AN <alec@nikts.nk.ukrtel.net>
                       |   Date: 26-Oct-98
 Nikolaev              |   Time: 15:52:47
 Ukraine               |
         This message was sent by XFMail
--------------------------------------------------------------------------



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~1998-10-26 13:52 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-10-26 13:23 Alternate disks for Indexes pierre@desertmoon.com
1998-10-26 13:52 ` Shulyak AN <alec@nikts.nk.ukrtel.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox