From: Michael Miyabara-McCaskey <mykarz@miyabara.com>
To: pgsql-sql@postgresql.org
Subject: Queries against multi-million record tables.
Date: Sat, 27 Jan 2001 13:45:25 -0800
Message-ID: <002201c088aa$75865690$c700a8c0@ncc1701e> (raw)
Hello all,
I am in the midst of taking a development DB into production, but the
performance has not been very good so far.
The DB is a decision based system, that currently has queries against tables
with up to 20million records (3GB table sizes), and at this point about a
25GB DB in total. {Later down the road up to 60million records and a DB of
up to 150GB is planned).
As I understand it, Oracle has some product called "parallel query" which
splits the table queried into 10 pieces and then does each one across as
many CPUs as possible, then puts it all back together again.
So my question is... based upon the messages I have read here, it does not
appear that PostgreSQL makes use of multiple CPUs, but only hands the next
query off to the next processor based upon operating system rules.
Therefore, what are some good ways to handle such large amounts of
information using PostgreSQL?
Michael Miyabara-McCaskey
Email: mykarz@miyabara.com
Web: http://www.miyabara.com/mykarz/
Mobile: +1 408 504 9014
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: mykarz@miyabara.com
Subject: Re: Queries against multi-million record tables.
In-Reply-To: <002201c088aa$75865690$c700a8c0@ncc1701e>
References: <002201c088aa$75865690$c700a8c0@ncc1701e>
* 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