| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | info(at)2ndquadrant(dot)com |
| Cc: | ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: pg_stat_statements |
| Date: | 2008-06-13 19:47:47 |
| Message-ID: | 14698.1213386467@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
> On Fri, 2008-06-13 at 17:33 +0900, ITAGAKI Takahiro wrote:
>> We can write sql statements in server logs and gather them using some
>> tools (pgfouine and pqa) even now, but statement logging has
>> unignorable overhead.
> I would prefer to look at ways to reduce the current overhead rather
> than change to another system entirely.
It's also the case that adding to the stats collector is hardly going to
have "ignorable" overhead. (And you're dreaming if you think you can do
it like pg_stat_activity, because this can't be a fixed-size array with
a trivial indexing scheme.)
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2008-06-13 19:51:19 | Re: TODO Item: Allow pg_hba.conf to specify host names along with IP addresses |
| Previous Message | Tom Lane | 2008-06-13 19:30:03 | Re: TODO Item: Allow pg_hba.conf to specify host names along with IP addresses |