Re: [HACKERS] Priorities for 6.6 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] Priorities for 6.6
Date
Msg-id 16906.928507649@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] Priorities for 6.6  (Hannu Krosing <hannu@trust.ee>)
Responses Re: [HACKERS] Priorities for 6.6
List pgsql-hackers
Hannu Krosing <hannu@trust.ee> writes:
> E. to make 2. and B., C, D. possible, some more fundamental changes in
>    fe/be-protocol may be needed. There seems to be some effort for a new
>    fe/be communications mechanism using CORBA. 
>    But my proposal would be to adopt the X11 protocol which is quite
>    light but still very clean, well understood and which can transfer
>    arbitrary data in an efficient way.

... but no one uses it for database work.  If we're going to go to the
trouble of overhauling the fe/be protocol, I think we should adopt
something fairly standard, and that seems to mean CORBA.

> F. As a lousy alternative to 1. fix the LO storage. Currently _all_ of
>    the LO files are kept in the same directory as the tables and
>    indexes. this can bog down the whole database quite fast

Yes.  I was thinking last night that there's no good reason not to
just stick all the LOs into a single relation --- or actually two
relations, one having a row per LO (which would really just act to tell
you what LOs exist, and perhaps store access-privileges info) and one
that has a row per LO chunk, with columns LONumber, Offset, Data rather
than just Offset and Data as is done now.  The existing index on Offset
would be replaced by a multi-index on LONumber and Offset.  In this
scheme the LONumbers need not be tied hard-and-fast to OIDs, but could
actually be anything you wanted, which would be much nicer for
dump/reload purposes.

However, I am loathe to put *any* work into improving LOs, since I think
the right answer is to get rid of the need for the durn things by
eliminating the size restrictions on regular tuples.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Backend sent 0x45 type while idle
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Open 6.5 items