Re: Indexes on separate disk ?

You sure can, Charlie.
We have our indexes, lightly used/smaller tables and heavily used/larger
tables split across several disks.
In a nutshell,
1. You just have to create the objects.
2. Then identify the objects using oid2name.
3. Shut down your database and move the objects.
4. Then put symlinks in their place pointing to their new destination.
5. Fire it back up.

(creating a reliable backup before this procedure is highly recommended)

Charlie Toohey wrote:
>
> I've looked around a lot and don't think this is possible with Postgres, but
> figured I would ask in case I missed something. Is it possible to configure
> things so that an index resides on a separate disk ? It doesn't look like it,
> since they both have to reside in the same database, and the entire contents
> of the database would reside underneath a single directory, and therefore on
> a single disk.
>
> Thanks
> Charlie
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

--
Bill MacArthur
Webmaster
DHS Club