Re: How much expensive are row level statistics? - Mailing list pgsql-performance

From Tom Lane
Subject Re: How much expensive are row level statistics?
Date
Msg-id 18416.1134691599@sss.pgh.pa.us
Whole thread Raw
In response to Re: How much expensive are row level statistics?  (Michael Fuhr <mike@fuhr.org>)
Responses Re: How much expensive are row level statistics?  (Kevin Brown <kevin@sysexperts.com>)
Re: How much expensive are row level statistics?  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-performance
Michael Fuhr <mike@fuhr.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

pgsql-performance by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: How much expensive are row level statistics?
Next
From: Tom Lane
Date:
Subject: Re: Overriding the optimizer