| From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
|---|---|
| To: | Greg Smith <gsmith(at)gregsmith(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: pg_stat_* collection |
| Date: | 2007-05-03 18:21:30 |
| Message-ID: | 1178216490.28383.277.camel@dogma.v10.wvs |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Thu, 2007-05-03 at 10:45 -0400, Greg Smith wrote:
> Today's survey is: just what are *you* doing to collect up the
> information about your system made available by the various pg_stat views?
> I have this hacked together script that dumps them into a file, imports
> them into another database, and then queries against some of the more
> interesting data. You would thing there would be an organized project
> addressing this need around to keep everyone from reinventing that wheel,
> but I'm not aware of one.
>
Is anyone out there collecting their own statistics? What's the easiest
way to take statistical samples of the data in a table without reading
the entire thing?
Regards,
Jeff Davis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron | 2007-05-03 19:15:23 | Re: Feature Request --- was: PostgreSQL Performance Tuning |
| Previous Message | Tobias Brox | 2007-05-03 16:16:46 | Re: pg_stat_* collection |