Home > mailing lists

Table Partitioning in Postgres: - Mailing list pgsql-general

From	Bodanapu, Sravan
Subject	Table Partitioning in Postgres:
Date	February 11, 2003 14:30:55
Msg-id	D9C90B51B105D511A3FB00508BFD70E2046DB3FD@mnmtkex1.nextelpartners.com Whole thread Raw
Responses	Re: Table Partitioning in Postgres: (Curt Sampson <cjs@cynic.net>)
List	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.

From: Viacheslav N Tararin
Date: 11 February 2003, 14:22:38
Subject: Re: Rights for view.

From: Bruno Wolff III
Date: 11 February 2003, 14:33:31
Subject: Re: Rights for view.