Changes between Initial Version and Version 1 of Ticket #3550, comment 6


Ignore:
Timestamp:
May 12, 2016, 11:59:18 PM (8 years ago)
Author:
robe

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #3550, comment 6

    initial v1  
    22
    33What if you copy, make an update to the table, and then vacuum analyze does it crash?
     4
     5I'm also thinking it might not hurt to reindex the table.  I've seen issues -- usually just with queries moving to a crawl because of corrupt index.  It almost always happens to me with gin or gist indexes that undergo massive updates.
     6
     7In those cases doing a
     8
     9
     10{{{
     11reindex table public.device_summary;
     12}}}
     13
     14
     15does the trick, though sometimes I have been forced to drop the offending index and recreate it.