| From: | Decibel! <decibel(at)decibel(dot)org> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Open issues for HOT patch |
| Date: | 2007-09-19 15:01:12 |
| Message-ID: | 3A083CE1-C08B-473C-9A31-67E991D02CCA@decibel.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sep 19, 2007, at 8:08 AM, Tom Lane wrote:
> Decibel! <decibel(at)decibel(dot)org> writes:
>> 3 isn't that important to me, but 4 is:
>> 4. Doesn't hammer the database to measure
>
>> And pgstattuple fails #4 miserably. Want to know the average dead
>> space
>> in a 500GB database? Yeah, right....
>
> So we could put a vacuum_cost_delay() in it ...
pg_stat_delay()? ;)
That's better than what we have now, without a doubt. But I'd still
prefer to have a table I can just read on the fly.
We do have a TODO to replace the current stats infrastructure with
something that has less overhead, right? :)
--
Decibel!, aka Jim C. Nasby, Database Architect decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-09-19 15:14:20 | curious regression failures (was Re: [PATCHES] PL/TCL Patch to prevent postgres from becoming multithreaded) |
| Previous Message | Guillaume Smet | 2007-09-19 15:00:24 | Re: like/ilike improvements |