| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Raimon Fernandez <coder(at)montx(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Extended Query, flush or sync ? |
| Date: | 2009-12-18 21:55:08 |
| Message-ID: | 12275.1261173308@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-interfaces |
Raimon Fernandez <coder(at)montx(dot)com> writes:
> It's not clear for me if I have to issue a flush or sync after each process of an extended query.
Basically, you send one of these at the points where you're going to
wait for an answer back. Sync is different from Flush in that it also
provides a resynchronization point after an error: when the backend hits
an error while processing a given message, it ignores following messages
up to the next Sync.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raimon Fernandez | 2009-12-18 23:40:06 | Re: Extended Query, flush or sync ? |
| Previous Message | Rory Campbell-Lange | 2009-12-18 21:48:03 | Re: Extracting SQL from logs in a usable format |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raimon Fernandez | 2009-12-18 23:40:06 | Re: Extended Query, flush or sync ? |
| Previous Message | Raimon Fernandez | 2009-12-18 21:44:10 | Extended Query, flush or sync ? |