Re: VACUUM Question - Mailing list pgsql-general

From Jim C. Nasby
Subject Re: VACUUM Question
Date
Msg-id 20060131195205.GY95850@pervasive.com
Whole thread Raw
In response to Re: VACUUM Question  (Chris Browne <cbbrowne@acm.org>)
List pgsql-general
On Thu, Jan 26, 2006 at 04:14:45PM -0500, Chris Browne wrote:
> > As for Reindex, I'm not entirely sure, I don't think you would benefit
> > from reindex because you aren't updating or deleting.  Can anyone comment
> > on this?  Is is possibile that a table with lots of inserts resulting in
> > lots of page splits etc could ever benifit form REINDEX?
>
> I could imagine a CLUSTER doing some good, and if that's the case,
> REINDEX could have some favorable results.  But you'd better have a
> real specific model as to why that would be...

Aside from the cluster case, are there any issues with how page splits
in the b-tree are done that could lead to better performance after a
REINDEX?
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-general by date:

Previous
From: "Justin Pasher"
Date:
Subject: Best way to handle table trigger on update
Next
From: Mott Leroy
Date:
Subject: help with locked table(s)/transactions(s)