| From: | Kenneth Marshall <ktm(at)rice(dot)edu> |
|---|---|
| To: | Decibel! <decibel(at)decibel(dot)org> |
| Cc: | Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org, Gregory Stark <stark(at)enterprisedb(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Martijn van Oosterhout <kleptog(at)svana(dot)org> |
| Subject: | Re: Maximum statistics target |
| Date: | 2008-03-20 19:48:20 |
| Message-ID: | 20080320194820.GF27394@it.is.rice.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Mar 20, 2008 at 11:17:10AM -0500, Decibel! wrote:
> On Mar 10, 2008, at 1:26 PM, Peter Eisentraut wrote:
>
> At some point I think it makes a lot more sense to just have VACUUM gather
> stats as it goes, rather than have ANALYZE generate a bunch of random IO.
>
> BTW, when it comes to the case of the OP, perhaps we can build enough
> intelligence for the system to understand when the stats follow some type
> of pattern (ie: a geometric distribution), and store the stats differently.
> --
> Decibel!, aka Jim C. Nasby, Database Architect decibel(at)decibel(dot)org
> Give your computer some brain candy! www.distributed.net Team #1828
>
+1 for opportunistically gathering stats during other I/O such as
vacuums and sequential scans. It would be interesting to have a hook
to allow processes to attach to the dataflow from other queries.
Cheers,
Ken
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeroen T. Vermeulen | 2008-03-20 20:13:41 | Re: Patch to update libpqxx's homepage in README |
| Previous Message | Sam Mason | 2008-03-20 19:23:32 | writing a MIN(RECORD) aggregate |