From eff0131f6d8df4f4c81414beb558fdc7c5244f64 Mon Sep 17 00:00:00 2001 From: Reedy Date: Sun, 17 May 2020 15:43:46 +0100 Subject: [PATCH] Update PostgreSQL supported version in docs/database/postgres.txt Change-Id: I9e49857e67f3351683dbbf0019d8301eaf43e59c (cherry picked from commit 39176163d20a7095e5a68338697f6a719371f1a6) --- docs/databases/postgres.txt | 25 ++++++++----------------- 1 file changed, 8 insertions(+), 17 deletions(-) diff --git a/docs/databases/postgres.txt b/docs/databases/postgres.txt index 6b266a6a77..c47a077b2e 100644 --- a/docs/databases/postgres.txt +++ b/docs/databases/postgres.txt @@ -1,6 +1,5 @@ This document describes the state of Postgres support in MediaWiki. - == Overview == Support for PostgreSQL has been available since version 1.7 @@ -10,14 +9,9 @@ Still, it is probably the most supported database after MySQL. Much of the work in making MediaWiki database-agnostic came about through the work of creating Postgres support. - == Required versions == -The current minimum version of PostgreSQL for MediaWiki is 8.1. -It is expected that this will be raised to 8.3 at some point, -as 8.1 and 8.2 are nearing end of life. - - +The current minimum version of PostgreSQL for MediaWiki is 9.2 == Database schema == @@ -80,7 +74,6 @@ referenced directly by the code (unlike sequence names). Most of the indexes in the file as of this writing are there due to production testing of expensive queries on a busy wiki. - == Keeping in sync with tables.sql == The script maintenance/postgres/compare_schemas.pl should be @@ -91,19 +84,17 @@ itself. This script has also been very useful in finding problems in maintenance/tables.sql itself, as it is very strict in the format it expects things to be in. :) - == MySQL differences == -The major differences between MySQL and Postgres are represented as -methods in the Database class. For example, implicitGroupby() is -true for MySQL and false for Postgres. This means that in those -places where the code does not add all the non-aggregate items -from the SELECT clause to the GROUP BY, we can add them in, but in -a conditional manner with the above method, as simply adding them -all in to the main query may cause performance problems with +The major differences between MySQL and Postgres are represented as +methods in the Database class. For example, implicitGroupby() is +true for MySQL and false for Postgres. This means that in those +places where the code does not add all the non-aggregate items +from the SELECT clause to the GROUP BY, we can add them in, but in +a conditional manner with the above method, as simply adding them +all in to the main query may cause performance problems with MySQL. - == Getting help == In addition to the normal venues (MediaWiki mailing lists -- 2.20.1