Re: [HACKERS] [hackers]development suggestion needed - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] [hackers]development suggestion needed
Date
Msg-id 28538.947829548@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] [hackers]development suggestion needed  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [HACKERS] [hackers]development suggestion needed
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Don Baccus
Date:
Subject: Re: [HACKERS] [hackers]development suggestion needed
Next
From: Mike Mascari
Date:
Subject: Re: Multiple Spindles ( Was: Re: [HACKERS][hackers]development suggestion needed )