Sunday, November 6, 2011

Postgresql - Reindexing a table

The argument is:

  • newly created indexes are faster

  • indexes tend to become bloated with frequent updates of keys.

I also found this interesting article related to the bloating issue.

I came to this subject brought by this error:

ERROR: could not read block 18875 of relation base/105574/105673: read only 0 of 8192 bytesERROR:

reindexing the table that triggered that error was a solution this time.

No comments:

Post a Comment