Quick Links

table size

From:	David McLoughlin <dmcloughlin(at)sherkin(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	table size
Date:	2003-09-23 09:35:57
Message-ID:	3F7013FD.2050209@sherkin.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

I have a table in my database which can grow very quickly. Is
there some way to partition the table so that when it reaches a certain size the
information in it is copied to a temporary table and the
original table is free again.

Or is this possible at all. If not is there any sort of perfomance
update I can add to speed up the queries on such a large table.

thanks

D

Responses

Re: table size at 2003-09-23 10:08:50 from Jason Godden
Re: table size at 2003-09-23 10:24:05 from Shridhar Daithankar
Re: table size at 2003-09-23 14:55:41 from Bruno Wolff III

Browse pgsql-general by date

	From	Date	Subject
Next Message	Jason Godden	2003-09-23 10:08:50	Re: table size
Previous Message	Maurizio Faini	2003-09-23 08:24:32	GET LAST ID INSERT