Re: attribute ordering The column presentation issue maybe should be cross referenced with the problem with rowtypes where the referenced table has dropped columns. This is the one where in plpgsql you do a select * into a rowtype of a table with dropped columns you get a mismatch on the types. Implementing the presentation ordering will probably give a solution to the rowtype problem.
elein On Saturday 28 June 2003 08:05, Jan Wieck wrote: > Tom Lane wrote: > > Bruce Momjian <[EMAIL PROTECTED]> writes: > >> Is the issue of many columns in a tuple the same issue as a SELECT > >> having many columns? > > > > I believe all the same inefficiencies need to be fixed whichever > > way you look at it. Probably "many columns in SELECT" is the more > > accurate description though. > > Together with the recent discussions about attribute reordering, it'd > make sense, if we have a "resentation order" different from the actual > physical tuple layout, that the table starts with all variable length > fields at the end. This would give a better utilization of attribute > offset caching. > > Don't know though, if this counts for much of the suffering. > > > Jan > > > > > regards, tom lane > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 6: Have you searched our list archives? > > > > http://archives.postgresql.org > > > > -- > #======================================================================# > # It's easier to get forgiveness for being wrong than for being right. # > # Let's break this rule - forgive me. # > #================================================== [EMAIL PROTECTED] # > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match > > -- ============================================================= [EMAIL PROTECTED] Database Consulting www.varlena.com PostgreSQL General Bits http:/www.varlena.com/GeneralBits/ "Free your mind the rest will follow" -- en vogue ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly