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: | Raw Message | Whole Thread | 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? |