From: Andrew Hammond <ahammond@ca.afilias.info>
To: Bill <bill@math.uchicago.edu>
Cc: pgsql-performance@postgresql.org
Subject: Re: postgresql and openmosix migration
Date: Wed, 23 Jun 2004 10:47:21 -0400
Message-ID: <40D997F9.7000700@ca.afilias.info> (raw)
In-Reply-To: <008201c4587e$b8856510$dfc58780@billnotebook>
References: <004001c45865$59cc9f20$dfc58780@billnotebook>
<200406220931.23780.josh@agliodbs.com>
<008201c4587e$b8856510$dfc58780@billnotebook>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Bill wrote:
| Ok, so maybe someone on this group will have a better idea. We have a
| database of financial information, and this has literally millions of
| entries. I have installed indicies, but for the rather computationally
| demanding processes we like to use, like a select query to find the
| commodity with the highest monthly or annual returns, the computer
generally
| runs unacceptably slow. So, other than clustring, how could I achieve a
| speed increase in these complex queries? Is this better in mysql or
| postgresql?
Postgres generally beats MySQL on complex queries. The easiest solution
to speed issues is to throw hardware at it. Generally, you're first
bound by disk, RAM then CPU.
1) Move your data over to an array of smallish 15kRPM disks. The more
spindles the better.
2) Use a 64 bit platform and take advantage of >4 GB memory.
There are dozens of options for the disk array. For the processing
platform, I'd recommend looking at Opteron. I've heard only good things
and their price is much more reasonable than the other options.
- --
Andrew Hammond 416-673-4138 ahammond@ca.afilias.info
Database Administrator, Afilias Canada Corp.
CB83 2838 4B67 D40F D086 3568 81FC E7E5 27AF 4A9A
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFA2Zf3gfzn5SevSpoRAr0HAJ0S/uVjuqYEuhMgdSAI3rfHK0ga1wCgwpHl
g+yuBYpAt58vnJWtX+wii1s=
=2fGN
-----END PGP SIGNATURE-----
Attachments:ahammond.vcf (text/x-vcard, 507B) download
begin:vcard
fn:Andrew Hammond
n:Hammond;Andrew
org:Afilias Canada Corp.;Operations
adr:Suite 204;;4141 Yonge Street;North York;Ontario;M2P 2A8;Canada
email;internet:ahammond@ca.afilias.info
title:Database Administrator
tel;work:416-673-4138
tel;fax:416-646-1541
tel;home:416-214-1109
tel;cell:647-285-7106
note;quoted-printable:I sign all emails with my GPG key. Fingerprint is:=0D=0A=
CB83 2838 4B67 D40F D086 3568 81FC E7E5 27AF 4A9A
x-mozilla-html:TRUE
url:http://www.afilias.info/
version:2.1
end:vcard
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: ahammond@ca.afilias.info, bill@math.uchicago.edu
Subject: Re: postgresql and openmosix migration
In-Reply-To: <40D997F9.7000700@ca.afilias.info>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox