| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Michael Fuhr <mike(at)fuhr(dot)org> |
| Cc: | Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com>, pgsql-performance(at)postgresql(dot)org, Carlos Benkendorf <carlosbenkendorf(at)yahoo(dot)com(dot)br> |
| Subject: | Re: How much expensive are row level statistics? |
| Date: | 2005-12-16 00:06:39 |
| Message-ID: | 18416.1134691599@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches pgsql-performance |
Michael Fuhr <mike(at)fuhr(dot)org> writes:
> Does the backend support, or could it be easily modified to support,
> a mechanism that would post the command string after a configurable
> amount of time had expired, and then continue processing the query?
Not really, unless you want to add the overhead of setting a timer
interrupt for every query. Which is sort of counterproductive when
the motivation is to reduce overhead ...
(It might be more or less free if you have statement_timeout set, since
there would be a setitimer call anyway. But I don't think that's the
norm.)
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dann Corbit | 2005-12-16 02:02:55 | Re: Which qsort is used |
| Previous Message | Michael Fuhr | 2005-12-15 23:44:48 | Re: How much expensive are row level statistics? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Brown | 2005-12-16 05:44:58 | Re: How much expensive are row level statistics? |
| Previous Message | Michael Fuhr | 2005-12-15 23:44:48 | Re: How much expensive are row level statistics? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-12-16 00:23:49 | Re: Overriding the optimizer |
| Previous Message | Michael Fuhr | 2005-12-15 23:44:48 | Re: How much expensive are row level statistics? |