All Questions

Filter by
Sorted by
Tagged with
0
votes
0answers
5 views

How to create multiple pool connection using Psycopg2 in Cloud Functions (GCP)

I am creating Cloud Functions for some queries to read and write in different databases. In GCP concept, I am connected to Cloud SQL - Postgres and using Psycopg2, tested locally - python postgres ...
1
vote
1answer
47 views

Speed up 180M+ rows returned by simple SELECT with PostgreSQL

I have performance issues on a SELECT statement which returns 180+ out of 220+ of millions of rows on my managed PostgreSQL. The table structure is the following: CREATE TABLE members ( id ...
1
vote
0answers
44 views

Dumping Postgres schema from Google cloud SQL

Now this may look trivial but it is a managed service so I don't have the superuser rights. And various schema/tables/sequences have different roles/users as their owners so I can't just use pg_dump ...