Re: Query performance - Mailing list pgsql-performance

From Rod Taylor
Subject Re: Query performance
Date
Msg-id 1088605644.12340.10.camel@jester
Whole thread Raw
In response to Re: Query performance  ("Bill" <bill@math.uchicago.edu>)
List pgsql-performance
> Can I get any better performance?

You can try bumping your sort memory way up (for this query only).

Another method would be to cluster the table by the symbol column
(eliminates the expensive sort).

If you could run a very simple calculation against open & close numbers
to eliminate a majority of symbols early, that would be useful as well.



pgsql-performance by date:

Previous
From: "Bill"
Date:
Subject: Re: Query performance
Next
From: Litao Wu
Date:
Subject: Re: reindex and copy - deadlock?