From: | Ole Gjerde <gjerde(at)icebox(dot)org> |
---|---|
To: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [HACKERS] Open 6.5 items |
Date: | 1999-06-07 17:33:58 |
Message-ID: | Pine.LNX.4.05.9906071226180.31034-100000@snowman.icebox.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Sun, 6 Jun 1999, Bruce Momjian wrote:
> I liked unlinking because it allowed old backends to still see the
> segments if they still have open file descriptors, and new backends can
> see there is no file there. That seemed nice, but you clearly
> demostrated it caused major problems. Maybe truncation is the answer.
> I don't know, but we need to resolve this for 6.5. I can't imagine us
> focusing on this like we have in the past few weeks. Let's just figure
> out an answer. I am on IRC now if someone can get on to discuss this. I
> will even phone someone in US or Canada to discuss it.
Personally, I think the right thing is to unlink the unused segments. For
the most part keeping them around is not going to cause any problems, but
I can't really think of any good reasons to keep them around. Keeping the
database directories clean is a good thing in my opinion.
> What is it on the backend that causes some backend to think there is
> another segment. Does it just go off the end of the max segment size
> and try to open another, or do we store the number of segments
> somewhere. I thought it was the former in sgml() area. I honestly don't
> care if the segment files stay around if that is going to be a reliable
> solution.
The new patch from Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> works. I believe it is
a reliable solution, I just don't agree it's the right one. That is
probably just a matter of opinion however. As his patch doesn't have any
immediate problems, so I vote for that to be included in 6.5.
Thanks,
Ole Gjerde
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-06-07 17:58:06 | Re: [HACKERS] Re: [COMMITTERS] 'pgsql/src/backend/parser gram.y' |
Previous Message | Tom Lane | 1999-06-07 17:28:26 | Re: [HACKERS] Re: [COMMITTERS] 'pgsql/src/backend/parser gram.y' |