Scaling with PostgreSQL 9.6 and Postgres-XLPrior to 9.6, if you had a 32 core system, needed to run one large query, and you were the only user on the system, that query would still just utilize one single core, with 31 cores largely idle • transferring to another process Postgres Conference China 2016 中国用户大会 PostgreSQL 9.6 pglogical • contrib module • In 9.6, no patching required to add in BDR – No global sequences • pglogical extension for logical postgres_fdw or PL/Proxy could be used Other • Postgres-XL (The PostgreSQL License) • Greenplum (Apache License) Postgres Conference China 2016 中国用户大会 Mixed Workload – HTAP Hybrid Transactional Analytical0 码力 | 87 页 | 1.16 MB | 1 年前3
PostgreSQL 16.1 DocumentationFunctions ............................................................................ 1588 51.2. Archive Module Callbacks ....................................................................... 1588 VI. Reference F.5. basebackup_to_shell — example "shell" pg_basebackup module ...................... 2806 F.6. basic_archive — an example WAL archive module ....................................... 2807 F.7. bloom — ............. 2973 F.40. sepgsql — SELinux-, label-based mandatory access control (MAC) security module ................................................................................................0 码力 | 3133 页 | 14.10 MB | 1 年前3
PostgreSQL 17beta1 US DocumentationFunctions ............................................................................ 1626 49.2. Archive Module Callbacks ....................................................................... 1626 VI. Reference basebackup_to_shell — example "shell" pg_basebackup module ...................... 2861 xx PostgreSQL 17beta1 Documentation F.5. basic_archive — an example WAL archive module ..................................... ............. 3027 F.38. sepgsql — SELinux-, label-based mandatory access control (MAC) security module ................................................................................................0 码力 | 3188 页 | 14.32 MB | 1 年前3
PostgreSQL 16.1 DocumentationFunctions ...................................................................... 1507 51.2. Archive Module Callbacks ................................................................. 1507 VI. Reference . 2660 F.5. basebackup_to_shell — example "shell" pg_basebackup module ................. 2663 F.6. basic_archive — an example WAL archive module .................................. 2664 F.7. bloom — bloom filter ............. 2824 F.40. sepgsql — SELinux-, label-based mandatory access control (MAC) security module ................................................................................................0 码力 | 2974 页 | 14.22 MB | 1 年前3
PostgreSQL 17beta1 A4 DocumentationFunctions ...................................................................... 1544 49.2. Archive Module Callbacks ................................................................. 1544 VI. Reference . 2702 F.4. basebackup_to_shell — example "shell" pg_basebackup module ................. 2705 F.5. basic_archive — an example WAL archive module .................................. 2706 F.6. bloom — bloom filter ............. 2866 F.38. sepgsql — SELinux-, label-based mandatory access control (MAC) security module ................................................................................................0 码力 | 3017 页 | 14.45 MB | 1 年前3
PostgreSQL 10.23 Documentationt1(proname name, prosrc text) WHERE proname LIKE 'bytea%'; The dblink function (part of the dblink module) executes a remote query. It is declared to return record since it might be used for any kind of functions for UUIDs, but the core database does not include any function for generating UUIDs, because no single algorithm is well suited for every ap- plication. The uuid-ossp module provides functions that that implement several standard algorithms. The pgcrypto module also provides a generation function for random UUIDs. Alternatively, UUIDs could be generated by client applications or other libraries invoked0 码力 | 2590 页 | 12.03 MB | 1 年前3
PostgreSQL 10.23 Documentationt1(proname name, prosrc text) WHERE proname LIKE 'bytea%'; The dblink function (part of the dblink module) executes a remote query. It is declared to return record since it might be used for any kind of functions for UUIDs, but the core database does not include any function for generating UUIDs, because no single algorithm is well suited for every application. The uuid-ossp module provides functions that that implement several standard algorithms. The pgcrypto module also provides a generation function for random UUIDs. Alternatively, UUIDs could be generated by client applications or other libraries invoked0 码力 | 2727 页 | 11.93 MB | 1 年前3
PostgreSQL 9.3.25 Documentation........................................779 33.13.2. C++ Application Development with External C Module ......................781 33.14. Embedded SQL Commands ........................................ t1(proname name, prosrc text) WHERE proname LIKE ’bytea%’; The dblink function (part of the dblink module) executes a remote query. It is declared to return record since it might be used for any kind of functions for UUIDs, but the core database does not include any function for generating UUIDs, because no single algorithm is well suited for every application. The uuid-ossp module provides functions that0 码力 | 3002 页 | 7.47 MB | 1 年前3
PostgreSQL 9.3 Documentation........................................825 33.13.2. C++ Application Development with External C Module .............................826 33.14. Embedded SQL Commands ................................. t1(proname name, prosrc text) WHERE proname LIKE ’bytea%’; The dblink function (part of the dblink module) executes a remote query. It is declared to return record since it might be used for any kind of functions for UUIDs, but the core database does not include any function for generating UUIDs, because no single algorithm is well suited for every application. The uuid-ossp module provides functions that0 码力 | 3183 页 | 7.53 MB | 1 年前3
PostgreSQL 9.5.25 Documentation
........................................836 33.13.2. C++ Application Development with External C Module ......................838 33.14. Embedded SQL Commands ........................................ t1(proname name, prosrc text) WHERE proname LIKE ’bytea%’; The dblink function (part of the dblink module) executes a remote query. It is declared to return record since it might be used for any kind of functions for UUIDs, but the core database does not include any function for generating UUIDs, because no single algorithm is well suited for every application. The uuid-ossp module provides functions that0 码力 | 2558 页 | 6.27 MB | 1 年前3
共 42 条
- 1
- 2
- 3
- 4
- 5













