Search Postgresql Archives

updating all records of a table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 indexes, should I drop/recreate those?

 

(I remember the bad-ole days with Oracle where table defragging and index rebuilding was something we had to do)

 

Thanks  for any help !


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux