All Questions

Filter by
Sorted by
Tagged with
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 ...