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.


http://www.postgresql.org/docs/9.0/static/sql-reindex.html

http://www.java2s.com/Code/PostgreSQL/Index/Rebuildsallindexesonatable.htm

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

http://www.thegeekstuff.com/2009/05/15-advanced-postgresql-commands-with-examples/

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