The view pg_file_settings provides a summary of the contents of the server's configuration file(s). A row appears in this view for each

PostgreSQL databases require periodic maintenance known as vacuuming. For many installations, it is sufficient to

The genetic algorithm (GA) is a heuristic optimization method which operates through randomized search. The set of possible solutions for

NameDROP INDEX -- remove an index Synopsis

NameDROP TEXT SEARCH CONFIGURATION -- remove a text search configuration Synopsis

The idea behind this dump method is to generate a file with SQL commands that, when fed back to the server, will recreate the database in the same state as it was at the time

PostgreSQL provides the standard SQL type boolean; see Table 8-19. The

In addition to the postgresql.conf file already mentioned, PostgreSQL uses two other manually-edited configuration

An alternative backup strategy is to directly copy the files that PostgreSQL uses to store the data in the database;

NameCREATE AGGREGATE -- define a new aggregate function Synopsis