Re: [GENERAL] 7.4Beta

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jan Wieck <JanWieck(at)Yahoo(dot)com>
Cc: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>, Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Peter Childs <Blue(dot)Dragon(at)blueyonder(dot)co(dot)uk>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [GENERAL] 7.4Beta
Date: 2003-08-15 18:49:41
Message-ID: 20020.1060973381@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Jan Wieck <JanWieck(at)Yahoo(dot)com> writes:
> I'm thinking instead of a way to "cache" entire executors for this. Each
> SPI plan used during a transaction would need it's own executor, and I
> don't know offhand what type and how much resources an executor requires
> (I think it's only some memory that get's initialized and the VFD's
> opened).

Hmm. This is probably more feasible now than it would have been a year
ago, because I did some cleanup work to ensure that executor state is
localized into a specific memory context. I'm not certain about the
amount of overhead either, but it's surely worth a try.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2003-08-15 18:52:23 Re: join of array
Previous Message Tom Lane 2003-08-15 18:46:15 Re: getting execution plans with multiple database connections

Browse pgsql-hackers by date

  From Date Subject
Next Message Dann Corbit 2003-08-15 18:53:30 Re: [GENERAL] 7.4Beta
Previous Message Kurt Roeckx 2003-08-15 18:46:18 Bounds error in LockMethodInit().