Quick Links

Table partition for very large table

From:	Yudie Gunawan <yudiepg(at)gmail(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	Table partition for very large table
Date:	2005-03-28 17:32:04
Message-ID:	e460d0c0503280932cd9b3e3@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

I have table with more than 4 millions records and when I do select
query it gives me "out of memory" error.
Does postgres has feature like table partition to handle table with
very large records.
Just wondering what do you guys do to deal with very large table?

Thanks!

Responses

Re: Table partition for very large table at 2005-03-28 17:52:55 from Scott Marlowe
Re: Table partition for very large table at 2005-03-28 17:56:20 from Joshua D. Drake
Re: Table partition for very large table at 2005-03-28 17:59:10 from Michael Fuhr

Browse pgsql-general by date

	From	Date	Subject
Next Message	Scott Marlowe	2005-03-28 17:52:55	Re: Table partition for very large table
Previous Message	Tom Lane	2005-03-28 17:22:01	Re: Can't pg_dumpall, claims database exists twice