Queries against multi-million record tables.

From: "Michael Miyabara-McCaskey" <mykarz(at)miyabara(dot)com>
To: <pgsql-general(at)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org>, <pgsql-novice(at)postgresql(dot)org>
Subject: Queries against multi-million record tables.
Date: 2001-01-31 04:16:39
Message-ID: 000b01c08b3c$9ca08cc0$c700a8c0@ncc1701e
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general pgsql-novice

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(at)miyabara(dot)com
Web: http://www.miyabara.com/mykarz/
Mobile: +1 408 504 9014

Browse pgsql-admin by date

  From Date Subject
Next Message Raghav Infotech Ltd [Chennai] 2001-01-31 11:08:16 pgadmin
Previous Message lbottorff 2001-01-30 22:51:03 When is a constraint too big?

Browse pgsql-general by date

  From Date Subject
Next Message Michael Miyabara-McCaskey 2001-01-31 04:17:22 Sizing of LARGE databases.
Previous Message Mike Hoskins 2001-01-31 00:31:52 Re: MySQL file system

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Miyabara-McCaskey 2001-01-31 04:17:22 Sizing of LARGE databases.
Previous Message GH 2001-01-31 01:31:41 Re: Starting postmaster error