Re: Auto Partitioning Patch - WIP version 1

Lists: pgsql-patches
From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, NikhilS <nikkhils(at)gmail(dot)com>, pgsql-patches(at)postgresql(dot)org
Subject: Re: Auto Partitioning Patch - WIP version 1
Date: 2008-03-26 17:50:20
Message-ID: 200803261750.m2QHoKA03623@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: 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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com

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


From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Auto Partitioning Patch - WIP version 1
Date: 2008-03-26 17:57:47
Message-ID: 20080326175747.GG29730@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-patches

Bruce Momjian escribió:

> 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.

Ahh, thanks for pointing it out. I think I will use an HTTP redirect.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Auto Partitioning Patch - WIP version 1
Date: 2008-03-26 18:14:00
Message-ID: 200803261814.m2QIE0027155@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-patches

Alvaro Herrera wrote:
> Bruce Momjian escribi?:
>
> > 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.
>
> Ahh, thanks for pointing it out. I think I will use an HTTP redirect.

How do you know which directory to redirect to?

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com

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


From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-patches(at)postgresql(dot)org
Subject: Re: Auto Partitioning Patch - WIP version 1
Date: 2008-03-26 18:23:02
Message-ID: 200803261823.m2QIN2805139@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-patches

Bruce Momjian wrote:
> Alvaro Herrera wrote:
> > Bruce Momjian escribi?:
> >
> > > 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.
> >
> > Ahh, thanks for pointing it out. I think I will use an HTTP redirect.
>
> How do you know which directory to redirect to?

I can't see how Apache redirects would work, but I suppose you could use
HTML redirect because you know at the time you are creating the message
file which directory to point to, but again the title bar will change
to relative once you do that.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com

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


From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Auto Partitioning Patch - WIP version 1
Date: 2008-03-26 18:30:35
Message-ID: 20080326183035.GH29730@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-patches

Bruce Momjian wrote:
> Alvaro Herrera wrote:

> > Ahh, thanks for pointing it out. I think I will use an HTTP redirect.
>
> How do you know which directory to redirect to?

The script gets the directory as a parameter.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support