dict_int
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

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

2025-01-10 15:47:30
pg_visibility
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

The pg_visibility module provides a means for examining the visibility map (VM) and page-level visibility information. It also provides functions

2025-01-10 15:47:30
pg_buffercache
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

The pg_buffercache module provides a means for examining what's happening in the shared buffer cache in real time. The

2025-01-10 15:47:30
earthdistance
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

The earthdistance module provides two different approaches to calculating great circle distances on the surface of the Earth. The one described

2025-01-10 15:47:30
bloom
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

bloom provides an index access method based on Bloom filters

2025-01-10 15:47:30
unaccent
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

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

2025-01-10 15:47:30
tsearch2
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

The tsearch2 module provides backwards-compatible text search functionality for applications that used tsearch2

2025-01-10 15:47:30
tsm_system_rows
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

The tsm_system_rows module provides the table sampling method SYSTEM_ROWS, which can be used in the

2025-01-10 15:47:30
SQL Key Words
  • References/Database/PostgreSQL/Appendixes/Appendixes

Table C-1 lists all tokens that are key words in the SQL standard and in PostgreSQL 9.6.0. Background information can be found in Section 4

2025-01-10 15:47:30
auto_explain
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

The auto_explain module provides a means for logging execution plans of slow statements automatically, without having to run

2025-01-10 15:47:30