New episode: "Decoupled storage and compute"

Nikolay and Michael discuss a listener question — about products that take #Postgres and transform it to something that decouples compute from storage (RDS #Aurora, GC #AlloyDB, #Neon etc.) and whether they see something like this landing upstream in the medium term.

🎙️ https://postgres.fm/episodes/decoupled-storage-and-compute

📺 https://youtu.be/HzBGIHtEJ3M

#postgresql

#Performance of your #database is a huge topic. One critical piece is running benchmarks, but do you really know how/why/when to benchmark?

Check out this blog post by @sky_vst on the philosophy of benchmarking #AlloyDB!

https://cloud.google.com/blog/products/databases/advice-for-testing-your-database-performance-on-google-cloud

#GoogleCloud

#Google Announces Preview of #AlloyDB Omni: Run a #PostgreSQL-Compatible Database Anywhere https://www.infoq.com/news/2023/04/google-cloud-alloydb-omni/

Getting ready for the first #opensource data infrastructure meetup in Milan!

Let’s talk about #database with #clickhouse and #alloydb!

Good food and good tech!

@aiven_io

Happening tonight!

Join us in Milan at 6PM for a night concentrated on #database: #AlloyDB from @googlecloud and #ClickHouse!

https://meetu.ps/e/LX7KJ/RtVCW/i

Getting your indexes right on #PostgreSQL can be an ever-evolving game of whack-a-mole with engineering. #AlloyDB builds in AI to help advise you on what indexes to create based on a multitude of factors. Check out this blog to explain it all in depth:

https://cloud.google.com/blog/products/databases/how-the-alloydb-index-advisor-helps-make-smart-indeces

BigLaunches: ICYMI, here's some Google Cloud analytics stuff that came out that might be useful!

1/5: Datastream support for BigQuery and Postgres is now generally available: https://cloud.google.com/blog/products/databases/serverless-replication-of-operational-data-into-bigquery

2/5: BigQuery is now available in the me-west1 (Israel) region: https://cloud.google.com/bigquery/docs/locations

3/5: There is a preview for BigQuery's "Add Data demo guide" which walks users through navigating the interface for common sources. Usability is always important: https://cloud.google.com/bigquery/docs/bigquery-web-ui#run_add_data_demo_guide

4/5: AlloyDB is now available in us-west2 (Los Angeles): https://cloud.google.com/alloydb/docs/locations

5/5: The 20GiB logical storage limit for query results for Azure Blog Storage and AWS S3 through BQ Omni is now GA: https://cloud.google.com/bigquery/quotas#query_jobs

#analytics #cloud #googlecloud #bigquery #bigdata #data #postgres #alloydb #googlecloud

I am curious if anybody have had a chance to test the AlloyDB Omni performance with applications and maybe even with a real workload. How is it working for you? I am testing it with different sizes and getting good results (HammerDB TPC-C). @googlecloud #AlloyDB #Omni

If you're around Milan and into the #Database world, this event is a must!

Milan Open Source Data Infrastructure Meetup on the 12th April to hear about two of the new cool databases: #AlloyDB and #ClickHouse from @googlecloud and @aiven_io

https://www.meetup.com/milano-open-source-data-infrastructure-meetup/events/292063757/

RT @GabeWeiss_
You've all probably heard me say #AlloyDB is #PostgreSQL compatible wha, a thousand times? Well, it is, and to hammer the point home even more, we made an awesome animated video about it too:

https://www.youtube.com/watch?v=88k-eB3Eon8&list=PLIivdWyY5sqLCsehDPydpIZ31Rmrm0TI9

You've all probably heard me say #AlloyDB is #PostgreSQL compatible wha, a thousand times (if not maybe I'm not trying hard enough)? Well, it is, and to hammer the point home even more, we made an awesome animated video about it too:

https://www.youtube.com/watch?v=88k-eB3Eon8&list=PLIivdWyY5sqLCsehDPydpIZ31Rmrm0TI9

Running my test AlloyDB in a VirtualBox VM on my mac with only 6Gb mem allocated to the VM. But it seems like the index advisor works correctly. Query exec time reduced from 18ms to less than 3ms @googlecloud #AlloyDB #Omni

My product team at Google just released a downloadable edition of #AlloyDB, its #PostgreSQL-compatible database engine loaded with lots of neat features like an index advisor and a columnar engine and so on and suchlike.

It's in preview! You can install it on any newish RHEL or Debian-like and try it out for free.

https://cloud.google.com/blog/products/databases/run-alloydb-anywhere

I co-authored the docs, by gar.

#Postgres #databases #TechWriting

And the time has come! If you haven’t tried AlloyDB in the Google cloud yet you can try it in your environment. You can run AlloyDB Omni anywhere. Read more in the blog https://cloud.google.com/blog/products/databases/get-started-with-alloydb-omni and in the launch announcement https://cloud.google.com/blog/products/databases/run-alloydb-anywhere
@googlecloud #postgres #AlloyDB

Is #AWS #Aurora paper the best way to understand #GCP #AlloyDB?

BigReleases: ICYMI, here's some #googlecloud data product updates that I found interesting!

1/4: AlloyDB is now available in more regions. See the list here: https://cloud.google.com/alloydb/docs/locations

2/4: BigQuery has the ability to set default values in columns, and this feature is now generally available.

https://cloud.google.com/bigquery/docs/default-values

3/4: BigQuery can now recursively call CTEs. That's pretty neat.

https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#with_clause

4/4: Spanner PostgreSQL now supports JSONB data types.

https://cloud.google.com/spanner/docs/working-with-jsonb

#cloud #analytics #googlecloud #alloydb #bigquery #spanner #postgres #databases

AlloyDB is available in 16 new regions of the Google Cloud around the globe. Read more in Sandy's latest blog post. Ping me if you need any help or are curious what AlloyDB is. @googlecloud #AlloyDB
https://cloud.google.com/blog/products/databases/alloydb-for-postgresql-now-available-globally

Not always my fault if my blog titles are too long. I've just added "Continuous Backup" as that's how #AlloyDB markets it 😂
---
RT @FranckPachot
What is your @PostgreSQL alternative to 🅾 Oracle Flashback Database / 🔶 Amazon Aurora Backtrack?
Is transactional DDL sufficient to protect application releases with DDL + DML on the DB?
🚀 @Yugabyte has distributed snapshots:
https://dev.to/yugabyte/pitr-snapshot-an-easy-flashback-backtrack-f…
https://twitter.com/FranckPachot/status/1536808557974327298

Custom alerts from Postgres Cloud SQL (or AlloyDB) from @sborden76 @googlecloud #AlloyDB #CloudSQL
---
RT @sborden76
Use Python + Google Cloud Logging to create custom AlloyDB for PostgreSQL or Google CloudSQL for Postgres alerts. https://stborden.wordpress.com/2023/02/03/leverage-google-cloud-logging-monitoring-for-custom-cloud-sql-for-postgres-or-alloydb-alerts/
https://twitter.com/sborden76/status/1621522127147995136

Recently Google announced the general availability (GA) of AlloyDB for PostgreSQL, a fully-managed, PostgreSQL-compatible database service providing scale-out compute and storage, integrated analytics, and AI/ML-powered management. #posttgresql #google #googlecloud #alloydb https://www.infoq.com/news/2022/12/google-cloud-alloydb-postgresql/