plaur782

pg_lake is an open source Postgres extension based on work done at Crunchy Data prior to the acquisition by Snowflake - you can find the repo here [1] and a blog post with more context on the project here [2]

[1] https://github.com/Snowflake-Labs/pg_lake

[2] https://www.snowflake.com/en/blog/engineering/pg-lake-postgr...

For more context, this is an out of cycle Postgres minor version release as a result of issues identified in the prior minor version release that occurred on November 14th.

These threads provide more details:

https://x.com/marcoslot/status/1857403646134153438

https://bsky.app/profile/marcoslot.com/post/3laywltkea226

Josh Berkus had a great talk on the history of Postgres forks and variants. Link below to slides from a version of this talk in 2009:

https://www.slideshare.net/pgconf/elephant-roads-a-tour-of-p...

A number of good options. Different folks have their favorites: https://www.postgresql.org/docs/books/

I appreciate the heads up. You are trying this page (https://www.crunchydata.com/products/crunchy-bridge/pricing/) and it isnt working for you?

Evidently it is smooshing:

https://redmonk.com/jgovernor/2022/03/31/on-postgres-contain...

No. You are not alone. There are still a number of organizations that are cautious about deploying databases in Kubernetes. That said, various third party surveys as well as anecdotal evidence of what we are seeing at Crunchy Data suggests that deploying databases on Kubernetes is increasingly common. The degree to which it makes sense often depends on whether or not the organization is standardizing around Kubernetes for their deployment model more generally.

Maybe worth checking out pgbackrest (https://pgbackrest.org/) as an open source external tool for Postgres backup / restore if you have not already.

There is an important distinction between community driven open source databases (ex: Postgres) and open source databases that are developed, maintained and owned by a single corporate sponsor.

Depending on requirements, there are an increasing number of options for "active-active" Postgres deployments. A colleague wrote this on a federated active-active configuration on Kubernetes: https://info.crunchydata.com/blog/active-active-postgres-fed...

This is the key point we see - most applications just do not generate write traffic that is beyond what a recent release of Postgres can handle.

Ultimately comes down to the right tool for the job. Larger organizations tend to short list a selection of databases to choose from as new applications create new data requirements. These tend to include a NoSQL option, some combination of legacy databases, a data caching or message broker tool, and an open source relational database. Postgres has a lot of momentum as the "new" relational option.

Twitter thread from Peter Geoghegan, committer of the feature:

https://twitter.com/petervgeoghegan/status/13494620034173788...

New PostgreSQL STIG includes updated guidance for PostgreSQL 9.6 through 12, including how to use SCRAM authentication, a new logging location for PostgreSQL 10+, and usage of built-in defined roles added in newer Postgres releases. The Crunchy Data PostgreSQL STIG also provides expanded information regarding the use of any Federal Information Processing Standard (FIPS) compliant operating systems.

Link to download the guide:

https://www.crunchydata.com/disa-postgres-security-guide/dis...

The year of Postgres is every year - or at least three of the last four years. Congratulations to the Postgres community on another great year.

Some potentially useful findings related to working with Postgres on an Apple ARM M1 MacBook Pro 2020 from a colleague:

https://info.crunchydata.com/blog/postgresql-benchmarks-appl...

Cooley Go is a great resource for legal agreements and forms commonly required by start ups (particularly venture backed startups). The site includes both the form templates and documentation generators. The site also includes a number of posts related to start up FAQs such as allocating initial founder equity, tax issues associated with equity incentives, etc.

For a deeper dive into the legal issues frequently encountered by venture backed start ups - check out the Entrepreneur's Guide to Business Law:

https://www.amazon.com/Entrepreneurs-Guide-Business-Law-eboo...

A colleague ran some Postgres performance benchmarks on the Apple M1 and found the performance to be impressive:

https://info.crunchydata.com/blog/postgresql-benchmarks-appl...

A lot of great talks here for folks interested in Postgres. A few highlights:

-- Find your slow queries, and fix them! - Stephen Frost (https://www.youtube.com/watch?v=d2jBnOh3Y54)

-- Advanced Data Modeling Techniques in PostgreSQL - Christopher Travers (https://www.youtube.com/watch?v=5uEZEf3nrNI)

-- Protect Your PostgreSQL Passwords: How SCRAM Works & Why You Need It - Jonathan S. Katz (https://www.youtube.com/watch?v=20p4zP_pvQU)

-- Community roadmap to sharding - Alexander Korotkov (https://www.youtube.com/watch?v=C4GJAjUcAtg)

-- CREATE STATISTICS - what is it for - Tomas Vondra (https://www.youtube.com/watch?v=xPorz6N8ogE)

An interesting take on the impact of this change:

https://threadreaderapp.com/thread/1336603153341550592.html

There is a bit more background on the approach and toolchain here:

https://info.crunchydata.com/blog/postgresql-benchmarks-appl...

https://github.com/gregs1104/pgbench-tools