Wed, 17 Apr 2024 18:11:33 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png 32 32 76301791 https://www.percona.com/blog/foreign-data-wrappers-in-postgresql-databases-postgres_fdw-dblink/ https://www.percona.com/blog/foreign-data-wrappers-in-postgresql-databases-postgres_fdw-dblink/#respond Wed, 03 Apr 2024 16:35:39 +0000 https://www.percona.com/blog/?p=95497 A Foreign Data Wrapper (FDW) is a feature in database management systems that can communicate with an external data source and access data without physically moving the data on a working local database.PostgreSQL implements portions of the SQL/MED specification, allowing access to data that resides outside PostgreSQL using regular SQL queries. Such data, which is […]]]> https://www.percona.com/blog/foreign-data-wrappers-in-postgresql-databases-postgres_fdw-dblink/feed/ 0 95497 https://www.percona.com/blog/postgresql-partitioning-using-traditional-methods/ https://www.percona.com/blog/postgresql-partitioning-using-traditional-methods/#respond Mon, 01 Apr 2024 11:00:45 +0000 https://www.percona.com/blog/?p=89092 This blog was originally published in July 2023 and was updated in April 2024.Partitioning is the concept of splitting large tables logically into smaller pieces for better performance of the database. In this article, we’ll discuss how to effectively use traditional partitioning methods in PostgreSQL to effectively split tables and improve database performance. Methods of […]]]> https://www.percona.com/blog/postgresql-partitioning-using-traditional-methods/feed/ 0 89092 https://www.percona.com/blog/partitioning-in-postgresql-with-pg_partman-serial-based-trigger-based/ https://www.percona.com/blog/partitioning-in-postgresql-with-pg_partman-serial-based-trigger-based/#respond Fri, 01 Dec 2023 14:54:18 +0000 https://www.percona.com/blog/?p=92167 The PostgreSQL partition manager pg_partman is an open source extension widely supported and actively maintained by the PostgreSQL community.  pg_partman is an extension that streamlines the creation and management of table partition sets, supporting both time-based and serial-based partitioning approaches. You can use pg_partman to automate and create partitions by breaking large tables into smaller […]]]> https://www.percona.com/blog/partitioning-in-postgresql-with-pg_partman-serial-based-trigger-based/feed/ 0 92167 https://www.percona.com/blog/postgresql-partitioning-made-easy-using-pg_partman-timebased/ https://www.percona.com/blog/postgresql-partitioning-made-easy-using-pg_partman-timebased/#comments Wed, 27 Sep 2023 12:08:21 +0000 https://www.percona.com/blog/?p=90893 PostgreSQL Partition Manager — ‘pg_partman’ — is an open source extension freely available, widely supported, and actively maintained by the PostgreSQL community.pg_partman creates and manages both time-based and serial-based table partition sets. Users use it to automate and create partitions by breaking large tables into smaller partitions for better performance.In this post, initially, we will […]]]> https://www.percona.com/blog/postgresql-partitioning-made-easy-using-pg_partman-timebased/feed/ 1 90893