All Questions
Tagged with google-cloud-sql postgresql
7
questions
0
votes
2answers
42 views
Efficient key value store in Postgres
I want to use Postgres(11 in CloudSQL) as an efficient key value store. I have about 200GB of dictionaries (average size is 10kB, the structure can be different and nested). I'm thinking about ...
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
1answer
70 views
Google Cloud SQL lacks raster2pgsql
Google Cloud SQL supports the PostGIS extension, but I haven't seen any documentation regarding how to work with raster data on it. To load raster data into a table, we have to use raster2pgsql driver....
1
vote
1answer
264 views
Set column to randomly chosen value from another table
Consider this:
UPDATE dest
SET dest_col = (SELECT s.src_col FROM source s
WHERE s.name = 'abc'
ORDER BY random() LIMIT 1 OFFSET 0);
My goal: Set dest.dest_col in ...
0
votes
1answer
115 views
How to configure PG text search dictionary through sql
I want to add terms to a text search dictionary without access to the file system shares/tsearch_data (specifically for google cloud SQL).
Is there a syntax to do this via SQL?
All I have found is "...
2
votes
0answers
54 views
taking a gcloud snapshot of a postgres database
Given a postgres database on a Google cloud virtual machine instance, are we guaranteed snapshot consistency if we call pg_start_backup(), sync(), then take a snapshot of the instance?
https://cloud....
1
vote
1answer
483 views
How to setup vault and Postgres in Google cloud to have the correct permissions?
The Problem
I am trying to setup Hashicorp vault and Postgres in Google Cloud.
I am using liquibase to manage the schema and when that does a migration, it retrieves a username/password from vault ...