Bug #75705 [NEW]: pg_field_type() slow and consumes CPU on a large database

From: dmitry dot kunilov at gmail dot com Operating system: PHP version: 7.2.0 Package: PostgreSQL related Bug Type: Bug Bug description:pg_field_type() slow and consumes CPU on a large database Description: ------------ Our database has around 25K tables. Whenever a PHP script does a first call to pg_field_type(), it consumes a lot of CPU, memory and network traffic. This is reproducible with all PHP versions from 5 to 7.2 The problem was narrowed down to the following query performed from ext/pgsql/pgsql.c get_field_name(): select oid,typname from pg_type As postgresql defines several types for each table in the database, the above query produces over 76K rows on our system. All of those are put into a hashmap by get_field_name(). Obviously, rowset types present in pg_type table cannot be used as field types, and have to be excluded from the query. -- Edit bug report at https://bugs.php.net/bug.php?id=75705&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=75705&r=trysnapshot54 Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=75705&r=trysnapshot55 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=75705&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=75705&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=75705&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=75705&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=75705&r=needscript Try newer version: https://bugs.php.net/fix.php?id=75705&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=75705&r=support Expected behavior: https://bugs.php.net/fix.php?id=75705&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=75705&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=75705&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=75705&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=75705&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=75705&r=dst IIS Stability: https://bugs.php.net/fix.php?id=75705&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=75705&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=75705&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=75705&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=75705&r=mysqlcfg