splitting a table?

From: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: splitting a table?
Date: 2003-06-20 14:02:43
Message-ID: 73309C2FDD95D11192E60008C7B1D5BB05FED47D@snt452.corp.bcbsm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Howdy:

Running PostgreSQL 7.2.1 on RedHat Linux 7.2.

I have a table with about 10 million records and
even though it's indexed on three key columns,
it's still pretty slow, I believe, because of the
size.

Is there a way to split the data so that I
can access all the records, but maintain
smaller tables?

Thanks!

-X

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Eckermann 2003-06-20 14:20:12 Re: How to get subscribe-nomail to working ?
Previous Message Tom Lane 2003-06-20 13:50:25 Re: debugging C functions