Обсуждение: lifetime of TubleTableSlot* returned by ExecProcNode
Hello,<br /><br />As per title, what is the lifetime of the virtual tuple TupleTableSlot* returned by ExecProcNode?<br /><br/>Any help would be appreciated.<br /><br />Regards,<br /><br />Bramandia R.<br /><br /><span class="HcCDpe"></span>
"Bramandia Ramadhana" <bramandia@gmail.com> writes:
> As per title, what is the lifetime of the virtual tuple TupleTableSlot*
> returned by ExecProcNode?
Until you next call that same plan node.
regards, tom lane
I see.
Hmm how if an upper level node needs to store (for future use) the TupleTableSlot* returned by lower level node, e.g. I create a specialized Sort Node which needs to read all tuples from lower level nodes. In this case, would it be necessary and sufficient to make a copy the TupleTableSlot ?
Regards,
Bramandia R.
On Fri, Dec 12, 2008 at 9:13 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Bramandia Ramadhana" <bramandia@gmail.com> writes:Until you next call that same plan node.
> As per title, what is the lifetime of the virtual tuple TupleTableSlot*
> returned by ExecProcNode?
regards, tom lane
"Bramandia Ramadhana" <bramandia@gmail.com> writes:
> Hmm how if an upper level node needs to store (for future use) the
> TupleTableSlot* returned by lower level node, e.g. I create a specialized
> Sort Node which needs to read all tuples from lower level nodes. In this
> case, would it be necessary and sufficient to make a copy the TupleTableSlot
It would be a pretty crummy way to approach it, because a Slot is not
intended to be a compact representation. You probably want to use a
tuplestore or tuplesort object instead.
regards, tom lane
I see. Thanks for the advice. I would research on how to use tuplestore object.
Regards,
Bramandia R.
On Sat, Dec 13, 2008 at 10:36 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Bramandia Ramadhana" <bramandia@gmail.com> writes:> Hmm how if an upper level node needs to store (for future use) theIt would be a pretty crummy way to approach it, because a Slot is not
> TupleTableSlot* returned by lower level node, e.g. I create a specialized
> Sort Node which needs to read all tuples from lower level nodes. In this
> case, would it be necessary and sufficient to make a copy the TupleTableSlot
intended to be a compact representation. You probably want to use a
tuplestore or tuplesort object instead.
regards, tom lane
After reading the source code for nodeHash.c and tuplesort.c, I decided to create new struct containing MinimumTuple and few members.
I am still wondering in one thing:
typedef struct HashJoinTupleData
{
struct HashJoinTupleData *next; /* link to next tuple in same bucket */
uint32 hashvalue; /* tuple's hash code */
/* Tuple data, in MinimalTuple format, follows on a MAXALIGN boundary */
} HashJoinTupleData;
typedef struct
{
void *tuple; /* the tuple proper */
Datum datum1; /* value of first key column */
bool isnull1; /* is first key column NULL? */
int tupindex; /* see notes above */
} SortTuple;
In HashJoinTupleData, the MinimalTupleData is appended at the end of the struct whereas in SortTuple, a pointer to MinimalTupleData is stored in tuple member.
What are the reasons for the difference? And when does one approach is more preferable than another?
Regards,
Bramandia R.
I am still wondering in one thing:
typedef struct HashJoinTupleData
{
struct HashJoinTupleData *next; /* link to next tuple in same bucket */
uint32 hashvalue; /* tuple's hash code */
/* Tuple data, in MinimalTuple format, follows on a MAXALIGN boundary */
} HashJoinTupleData;
typedef struct
{
void *tuple; /* the tuple proper */
Datum datum1; /* value of first key column */
bool isnull1; /* is first key column NULL? */
int tupindex; /* see notes above */
} SortTuple;
In HashJoinTupleData, the MinimalTupleData is appended at the end of the struct whereas in SortTuple, a pointer to MinimalTupleData is stored in tuple member.
What are the reasons for the difference? And when does one approach is more preferable than another?
Regards,
Bramandia R.
On Sat, Dec 13, 2008 at 10:36 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Bramandia Ramadhana" <bramandia@gmail.com> writes:> Hmm how if an upper level node needs to store (for future use) theIt would be a pretty crummy way to approach it, because a Slot is not
> TupleTableSlot* returned by lower level node, e.g. I create a specialized
> Sort Node which needs to read all tuples from lower level nodes. In this
> case, would it be necessary and sufficient to make a copy the TupleTableSlot
intended to be a compact representation. You probably want to use a
tuplestore or tuplesort object instead.
regards, tom lane