[Bizgres-general] partitioned tables and indexes

[Simon Riggs]

On Thu, 2006-03-16 at 22:39 -0800, Luke Lonergan wrote:
 
> > Also each table represents about 2 Go and I have only 1 Go of RAM. I
> > have red that table size must not be to big as my RAM amount ! I want to
> > knaw if this rules will be valid for my oxn context.
> 
> Your table size can be very much larger than your RAM amount if you like.

Yes, there is no actual restriction on partition size.

If you keep your partitions smaller than memory, then if you have a
time-based partition the latest one will be in memory. This assist both
index insertion time and query speed.

Best Regards, Simon Riggs