| From: | deststar <deststar(at)blueyonder(dot)co(dot)uk> |
|---|---|
| To: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Deferred trigger queue to disk |
| Date: | 2003-06-27 21:17:33 |
| Message-ID: | 3EFCB46D.2020803@blueyonder.co.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
All this does is put all the trigger events given to it after a certain
number out to disk in DeferredTriggerAddEvent; then read them as
necessary in DeferredTriggerInvokeExec.
The certain number after which it moves to disk is currently, &
arbiterily, 100000 defined by this line in trigger.h:
#define max_deferred_trigger_mem_queue 100000
It has passed the regression checks on Linux (RH9ish) and cygwin.
Also include is a quick test script I used
This is my first patch of any size so please review carefully.
regards,
- Stuart
| Attachment | Content-Type | Size |
|---|---|---|
| trigger.c.diff | text/plain | 25.3 KB |
| trigger.h.diff | text/plain | 730 bytes |
| trig_tst.sql | text/plain | 2.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2003-06-27 21:55:53 | Re: Missing array support |
| Previous Message | Nabil Sayegh | 2003-06-27 20:21:17 | Re: connectby_reverselookup() |