The recommended partitioning guideline is if your table exceeds 2G
Partitioning benefits:
1. Purging old data very quickly (this is one of the biggest
benefits...especially if you have to purge very often...dont even
think of using DELETE)
2. Performance for certain types of queries where full t
On Monday 28 December 2009 23:59:43 Andres Freund wrote:
> On Monday 28 December 2009 23:54:51 Andres Freund wrote:
> > On Saturday 12 December 2009 21:38:41 Andres Freund wrote:
> > > On Saturday 12 December 2009 21:36:27 Michael Clemmons wrote:
> > > > If ppl think its worth it I'll create a tick
On Tuesday 29 December 2009 11:48:10 Greg Stark wrote:
> On Tue, Dec 29, 2009 at 2:05 AM, Andres Freund wrote:
> > Reads Completed:2,8KiB Writes Completed: 2362,
> > 29672KiB New:
> > Reads Completed:0,0KiB Writes Completed: 550,
> > 5960KiB
>
>
On Tue, Dec 29, 2009 at 2:05 AM, Andres Freund wrote:
> Reads Completed: 2, 8KiB Writes Completed: 2362,
> 29672KiB
> New:
> Reads Completed: 0, 0KiB Writes Completed: 550,
> 5960KiB
It looks like the new method is only doing 1/6th as much i/o. Do
