| From: | Claudio Freire <klaussfreire(at)gmail(dot)com> |
|---|---|
| To: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> |
| Cc: | Anne Rosset <arosset(at)collab(dot)net>, tv(at)fuzzy(dot)cz, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Slow query postgres 8.3 |
| Date: | 2011-04-12 07:33:50 |
| Message-ID: | BANLkTin7x1t4dhjqpSa6+EJ2MEeWmSNNwg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
I actually implemented a statistical system for measuring these kinds
of correlations.
It's complex, but it might be adaptable to pgsql. Furthermore, one of
the latest projects of mine was to replace the purely statistical
approach with SVCs.
Too bad I won't be able to devote any time to that project before september.
On Mon, Apr 11, 2011 at 6:59 PM, Kevin Grittner
<Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> There has been much talk lately about how to make
> it smarter about that, but right now there's no general solution,
> and workarounds can be tricky.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Claudio Freire | 2011-04-12 07:42:27 | Re: performance problem with LIMIT (order BY in DESC order). Wrong index used? |
| Previous Message | Arjen van der Meijden | 2011-04-12 07:31:20 | Re: Linux: more cores = less concurrency. |