Re: Auto Partitioning Patch - WIP version 1 - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: Auto Partitioning Patch - WIP version 1
Date
Msg-id 200803261750.m2QHoKA03623@momjian.us
Whole thread Raw
In response to Auto Partitioning Patch - WIP version 1  (NikhilS <nikkhils@gmail.com>)
Responses Re: Auto Partitioning Patch - WIP version 1  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-patches
bruce wrote:
> > I am assuming you use hard links -- obviously this doesn't work with
> > symlinks.  (My script creates hard links.)
>
> I was using symlinks.  I try to avoid hardlinks that cross directories
> --- not sure why, probably because I can't easily manage them to find
> out what something is linked to without playing with inodes.  You are
> right that if I used hard-links I put things in a separate directory,
> and the hard links would still contain the email, though if the email
> has been removed, should we still be returning it from a query?  I
> suppose I could delete items with only one link.
>
> Well, if I move the permanent links to another directory, as you
> suggest, I am going to invalidate every link.  Maybe we should wait for
> this commit fest to end and then I can create a permanent link directory
> and use hard links.
>
> Or is everyone OK with invalidating all the permanent links now.

OK, I remember now.  The problem wasn't symlinks but that mhonarc
generates URLs relative to the current directory.  If we have message-id
files outside the directory, links like "Thread Next" will not work.  We
could try to change those to absolute with a script.  The community
archives are going to have the same problem.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://postgres.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-patches by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Moving snapshot code around
Next
From: Alvaro Herrera
Date:
Subject: Re: Auto Partitioning Patch - WIP version 1