[GENERAL] updating all records of a table

2011-03-03 Thread Gauthier, Dave
Hi: I have to update all the records of a table. I'm worried about what the table will look like in terms of fragmentation when this is finished. Is there some sort of table healing/reorg/rebuild measure I should take if I want the resulting table to operate at optimal efficiency? What about

Re: [GENERAL] updating all records of a table

2011-03-03 Thread Joshua D. Drake
On Thu, 2011-03-03 at 20:03 -0700, Gauthier, Dave wrote: > Hi: > > I have to update all the records of a table. I'm worried about what > the table will look like in terms of fragmentation when this is > finished. Is there some sort of table healing/reorg/rebuild measure I > should take if I want

Re: [GENERAL] updating all records of a table

2011-03-04 Thread Andrew Sullivan
On Thu, Mar 03, 2011 at 08:03:59PM -0700, Gauthier, Dave wrote: > Hi: > > I have to update all the records of a table. I'm worried about what the > table will look like in terms of fragmentation when this is finished. Is > there some sort of table healing/reorg/rebuild measure I should take if

Re: [GENERAL] updating all records of a table

2011-03-04 Thread Vibhor Kumar
On Mar 4, 2011, at 5:17 PM, Andrew Sullivan wrote: > On Thu, Mar 03, 2011 at 08:03:59PM -0700, Gauthier, Dave wrote: >> Hi: >> >> I have to update all the records of a table. I'm worried about what the >> table will look like in terms of fragmentation when this is finished. Is >> there some

Re: [GENERAL] updating all records of a table

2011-03-04 Thread Rob Sargent
On 03/04/2011 04:54 AM, Vibhor Kumar wrote: > > On Mar 4, 2011, at 5:17 PM, Andrew Sullivan wrote: > >> On Thu, Mar 03, 2011 at 08:03:59PM -0700, Gauthier, Dave wrote: >>> Hi: >>> >>> I have to update all the records of a table. I'm worried about what the >>> table will look like in terms of

Re: [GENERAL] updating all records of a table

2011-03-04 Thread Gauthier, Dave
AM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] updating all records of a table On 03/04/2011 04:54 AM, Vibhor Kumar wrote: > > On Mar 4, 2011, at 5:17 PM, Andrew Sullivan wrote: > >> On Thu, Mar 03, 2011 at 08:03:59PM -0700, Gauthier, Dave wrote: >>> Hi: >&g

Re: [GENERAL] updating all records of a table

2011-03-04 Thread Chris Browne
robjsarg...@gmail.com (Rob Sargent) writes: > On 03/04/2011 04:54 AM, Vibhor Kumar wrote: >> >> On Mar 4, 2011, at 5:17 PM, Andrew Sullivan wrote: >> >>> On Thu, Mar 03, 2011 at 08:03:59PM -0700, Gauthier, Dave wrote: Hi: I have to update all the records of a table. I'm worried ab

Re: [GENERAL] updating all records of a table

2011-03-05 Thread ray
This has been a great thread! I am missing something because I do not know what CTAS is. WOuld someone please help me understand. ray -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] updating all records of a table

2011-03-05 Thread Martijn van Oosterhout
On Sat, Mar 05, 2011 at 07:38:23AM -0800, ray wrote: > This has been a great thread! I am missing something because I do not > know what CTAS is. WOuld someone please help me understand. Create Table As Select. Have a nice day, -- Martijn van Oosterhout http://svana.org/kleptog/ > Patriot

Re: [GENERAL] updating all records of a table

2011-03-05 Thread Willy-Bas Loos
you might consider lowering the fillfactor a bit. It will consume more space, but it will make updates and inserts faster. http://www.postgresql.org/docs/8.4/interactive/sql-createtable.html : fillfactor (integer) The fillfactor for a table is a percentage between 10 and 100. 100 (complete packin