Table Partitioning in Postgres:

From: "Bodanapu, Sravan" <Sravan(dot)Bodanapu(at)NextelPartners(dot)com>
To: "PGSQL General (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Table Partitioning in Postgres:
Date: 2003-02-11 16:30:45
Message-ID: D9C90B51B105D511A3FB00508BFD70E2046DB3FD@mnmtkex1.nextelpartners.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

We are trying to migrate a database from Oracle to Postgres which is about
150Gig.
How do you setup and maintain Big tables having around 20-30 million rows ?
Is there a way to setup table partitioning ? How can I improve the Postgres
Database performance for such a bid database ?
Please advice.

Thanks,

- Sravan.


Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-02-11 16:44:05 Re: Is Hash Agg being used? 7.4 seems to handle this query worse than 7.3
Previous Message Viacheslav N Tararin 2003-02-11 16:28:02 Re: Rights for view.