Re: Query performance

From: Rod Taylor <pg(at)rbt(dot)ca>
To: Bill <bill(at)math(dot)uchicago(dot)edu>
Cc: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Query performance
Date: 2004-06-30 14:27:25
Message-ID: 1088605644.12340.10.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Litao Wu 2004-06-30 15:08:16 Re: reindex and copy - deadlock?
Previous Message Bill 2004-06-30 13:47:03 Re: Query performance