agora inbox for pgsql-performance@postgresql.org
help / color / mirror / Atom feedFrom: Bill <bill@math.uchicago.edu>
To: pgsql-performance@postgresql.org
Subject: Query performance
Date: Sun, 27 Jun 2004 22:26:19 -0500
Message-ID: <BILLSA1XvpFVjCRGryW00000002@bill.fefferman.org> (raw)
Actually, I have some queries that are slow, however I was wondering if you
could help me write a query that is rather simple, but I, as a true database
novice, can't seem to conjure. So we have stocks, as I have previously
said, and I have a huge table which contains all of the opening and closing
prices of some stocks from each day. What I like to do, in English, for
each stock in each day is find a ratio: abs(closing-opening)/opening. Then
I would like to average all of the ratios of each day of each individual
stock together to find a final ratio for each stock, then I would like to
find the highest average, to find the best performing stock. So what query
can I use, and (as is appropriate for this group), how can it be optimized
to run the fastest?
view thread (48+ messages) latest in thread
Message-ID: <BILLSA1XvpFVjCRGryW00000002@bill.fefferman.org>
Permalink: ../BILLSA1XvpFVjCRGryW00000002@bill.fefferman.org/
Also on: postgresql.org/message-id/BILLSA1XvpFVjCRGryW00000002@bill.fefferman.org
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: bill@math.uchicago.edu
Subject: Re: Query performance
In-Reply-To: <BILLSA1XvpFVjCRGryW00000002@bill.fefferman.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox