On exclusion constraints and validity dates

2024-08-24 Thread Justin Giacobbi
Hello, I have an issue that on the surface seems orthogonal to existing functionality. I'm trying to dynamically update validity ranges as new s replace old s. In a nutshell the problem looks like this: psqlprompt=# select * from rangetest; id | rangecol +-

Re: About replication minimal disk space usage

2024-08-24 Thread Tomas Vondra
On 8/24/24 14:18, Manan Kansara wrote: > Hello All, > I have my self hosted postgres server on aws with 16gb disk space > attached to it for ml stuff and analysis stuff we are using vertex ai so > i have setup live replication of postgres using data stream service to > BigQuery table.  We use BigQu

About replication minimal disk space usage

2024-08-24 Thread Manan Kansara
Hello All, I have my self hosted postgres server on aws with 16gb disk space attached to it for ml stuff and analysis stuff we are using vertex ai so i have setup live replication of postgres using data stream service to BigQuery table. We use BigQuery table as data warehouse because we have so ma