In some situations it is worthwhile to rebuild indexes periodically with the REINDEX command or a series

dict_int is an example of an add-on dictionary template for full-text search. The motivation for this example dictionary is to control the indexing

NameSTART TRANSACTION -- start a transaction block Synopsis

In the previous chapter we have covered the basics of using SQL to store and access your data in PostgreSQL

SQL is a strongly typed language. That is, every data item has an associated data type which determines its behavior and allowed usage.

NameVACUUM -- garbage-collect and optionally analyze a database Synopsis

This section covers implementation details and other tricks that are useful for implementers of SP-GiST operator classes to know.

NameCREATE OPERATOR CLASS -- define a new operator class Synopsis

NameCREATE TABLE -- define a new table Synopsis

unaccent is a text search dictionary that removes accents (diacritic signs) from lexemes. It's a filtering dictionary, which means its output