Re: [HACKERS] Planning final assault on query length limits

From: Vadim Mikheev <vadim(at)krs(dot)ru>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Brook Milligan <brook(at)biology(dot)nmsu(dot)edu>, maillist(at)candle(dot)pha(dot)pa(dot)us, meskes(at)postgreSQL(dot)org, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Planning final assault on query length limits
Date: 1999-10-22 02:17:21
Message-ID: 380FC931.EB9DDFA5@krs.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
>
> Brook Milligan <brook(at)biology(dot)nmsu(dot)edu> writes:
> >> Jan, does this mean that we can also lose the "rewrite string too big"
> >> problem with rules?
>
> > No. We have to have long tuples.
>
> > Darn. Oh well, I guess this is a major step in that direction.
>
> I'm hoping that once this is done, someone who knows the guts of the
> storage managers better than I will feel motivated to work on letting
> stored tuples cross block boundaries. (Paging Vadim...) That seems
> to be the last piece of the puzzle.

You know that I'm busy with WAL...
And I already made some step in big tuples dirrection
when made memory/disk tuple presentations different -:)

typedef struct HeapTupleData
{
uint32 t_len; /* length of *t_data */
ItemPointerData t_self; /* SelfItemPointer */
HeapTupleHeader t_data; /* */
^^^^^^^^^^^^^^^^^^^^^^
On-disk data

} HeapTupleData;

I hope that something could be added here for tuple chunks...
TupleTableSlot.ttc_buffer (and ttc_shouldFree?) is good candidate
to be moved here from TupleTableSlot.

As for smgr part - it's not hard at all.

Vadim

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 1999-10-22 03:42:28 Re: [HACKERS] Planning final assault on query length limits
Previous Message Peter Eisentraut 1999-10-22 00:36:50 Re: [HACKERS] New psql startup banner