Re: Slow query postgres 8.3 - Mailing list pgsql-performance

From Claudio Freire
Subject Re: Slow query postgres 8.3
Date
Msg-id BANLkTin7x1t4dhjqpSa6+EJ2MEeWmSNNwg@mail.gmail.com
Whole thread Raw
In response to Re: Slow query postgres 8.3  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Slow query postgres 8.3
List 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.Grittner@wicourts.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.

pgsql-performance by date:

Previous
From: Arjen van der Meijden
Date:
Subject: Re: Linux: more cores = less concurrency.
Next
From: Claudio Freire
Date:
Subject: Re: performance problem with LIMIT (order BY in DESC order). Wrong index used?