Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-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


pgsql-novice by date

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

pgsql-admin by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group