| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Don Baccus <dhogaza(at)pacifier(dot)com>, Xun Cheng <xun(at)cs(dot)ucsb(dot)edu>, pgsql-hackers(at)postgreSQL(dot)org |
| Subject: | Re: [HACKERS] [hackers]development suggestion needed |
| Date: | 2000-01-14 06:20:22 |
| Message-ID: | 200001140620.BAA04371@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > ...
> > Or we could continue to use symlinks, and just create them ourselves in
> > the backend.
>
> But you'd still need some built-in understanding about where the table
> is Really Supposed To Be, because you'd need to be able to create and
> delete the symlinks on the fly when the table grows past a 1-Gb segment
> boundary (or is shrunk back again by vacuum!).
>
> AFAICS, a reasonable solution still requires storing a location path
> for each table --- so you might as well just use that path directly.
Makes sense. The only advantage to symlinks is that you could use that
information in places you need it, and for normal access use the
symlinks. You wouldn't have to carry around that info as much.
--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2000-01-14 06:22:29 | Re: [HACKERS] [hackers]development suggestion needed |
| Previous Message | Bruce Momjian | 2000-01-14 06:16:17 | Re: Multiple Spindles ( Was: Re: [HACKERS] [hackers]development suggestion needed ) |