Re: [PERFORM] Foreign key performance

Поиск
Список
Период
Сортировка
От Kevin Brown
Тема Re: [PERFORM] Foreign key performance
Дата
Msg-id 20030421000933.GP1833@filer
обсуждение исходный текст
Ответ на Re: [PERFORM] Foreign key performance  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [PERFORM] Foreign key performance
Список pgsql-hackers
Tom Lane wrote:
> Stephan Szabo <sszabo@megazone23.bigpanda.com> writes:
> > Okay, this changes the second paragraph of that comment.  I left in the
> > comment that's really similar next to where I actually do the selection of
> > which start point to use.
> 
> This had a bit of a problem yet: the loop in deferredTriggerInvokeEvents
> expects 'prev_event' to point to the list entry just before 'event'.
> A nice byproduct of fixing that is we don't uselessly rescan the last list
> entry.  I also tried to improve the comments a little.  You can see what
> I actually applied at
>
> http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/commands/trigger.c

Any chance of backporting these changes to 7_3_STABLE (when you're
satisfied they don't break anything)?  Just looking at the CVS log for
trigger.c, it appears there have been enough changes since then that
it might not be easy to do (and since it's not necessarily a "bug fix"
as such, it might not qualify for backporting to a stable version).

Even if it's not something that can be put into another release of
7.3, it would certainly be useful to me.  It might be useful to enough
people to justify releasing it as a patch on -patches, if nothing
else.

I'd do it myself but I don't understand the trigger code at all (and
if there's any documentation you can point me to that describes the
various functions and supporting data structures in trigger.c, that
would help a lot), and I'd rather not touch something like that until
I understand it thoroughly.


-- 
Kevin Brown                          kevin@sysexperts.com



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: New flex
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [PERFORM] Foreign key performance