Question : We have been trying to partition a Postgres database on google cloud using the built-in Postgres declarative partitioning […]
postgres_fdw performance is slow
Question : The following query on a foreign takes about 5 seconds to execute on 3.2 million rows: SELECT x.”IncidentTypeCode”, […]
How do I get PostgreSQL FDW to push down the LIMIT to the (single) backend server?
Question : I’ve set up a PostgreSQL FDW server with the following table, sharded by user_id over four servers: CREATE […]
Create foreign key on foreign table in postgresql [duplicate]
Question : This question already has answers here: Foreign Key (references) constraint on PostgreSQL Foreign Data Wrapper? (2 answers) Closed […]
How often is Postgres parsing a foreign table based on file_fdw?
Question : I have a foreign table defined with file_fdw, which reads the data from a CSV file. Postgresql parses […]
Create shared user mapping in PostgreSQL foreign data wrapper server
Question : We are using a foreign data wrapper to query across databases on a single PostgreSQL RDS. The foreign […]
ORDER BY too slow in Foreign Table using postgres_fdw
Question : PostgreSQL v9.6, postgres_fdw Foreign table CREATE FOREIGN TABLE user_info ( id bigint , info jsonb ) SERVER server_test_fdw […]
how to add a query to postgres and have it show up as a table
Question : I’m not sure what technology I need because I’m not a DBA, but I’m sure there’s a good […]
How do I set the option use_remote_estimate?
Question : Where do I set the “Cost Estimation Options” for postgres_fdw. Specifically I want to add use_remote_estimate. test=# SET […]
Copy large object field into remote PostgreSQL DB [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]