| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Harsh Azad" <harsh(dot)azad(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Index files |
| Date: | 2007-09-14 03:33:23 |
| Message-ID: | 18989.1189740803@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
"Harsh Azad" <harsh(dot)azad(at)gmail(dot)com> writes:
> Where are the database index files located in the $PGDATA directory?
Read
http://www.postgresql.org/docs/8.2/static/storage.html
> I was
> thinking on soft linking them to another physical hard disk array.
Manual symlink management, while not impossible, pretty much sucks
... especially if your tables are big enough that you actually need to
do this. Use a tablespace instead. (If you are on a PG version that
hasn't got tablespaces, you are more than overdue to upgrade.)
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2007-09-14 04:23:00 | Re: When/if to Reindex |
| Previous Message | Ow Mun Heng | 2007-09-14 03:09:49 | Re: Index files |