splitting a table? - Mailing list pgsql-general

From Johnson, Shaunn
Subject splitting a table?
Date
Msg-id 73309C2FDD95D11192E60008C7B1D5BB05FED47D@snt452.corp.bcbsm.com
Whole thread Raw
Responses Re: splitting a table?  (Richard Huxton <dev@archonet.com>)
List 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: debugging C functions
Next
From: Jeff Eckermann
Date:
Subject: Re: How to get subscribe-nomail to working ?