[PHPBB3-16686] Simplify get_database_size() SQL query for PostgreSQL

XML

Word

Printable

Details

Type: Improvement
Status: Closed (View Workflow)
Priority: Minor
Resolution: Fixed
Affects Version/s: 3.3.2
Fix Version/s: 3.3.4-RC1
Component/s: ACP, Database Abstraction Layer (DBAL)
Labels:
- back-end
- postgresql
Environment:
Nginx 1.19.6, PostgreSQL 13.1, PHP 7.4.14

Description

Currently it makes 3 queries to get database size:

Check if function pg_database_size()
exists
Get the database OID
Finally, get database size

It could be rewritten to use the function pg_database_size() directly, which is available since PostgreSQL 8.1, and phpBB according to the user guide requires 8.3 or greater.

Attachments

Activity

People

Assignee:: Marc

Reporter:: AbaddonOrmuz [X] (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 15/Jan/21 6:52 PM

Updated:: 15/Jan/21 9:35 PM

Resolved:: 15/Jan/21 9:09 PM