はてなブックマーク

GitLab, thanks for using PostgreSQL 9.6 and its replication and backup facilities. We’re sorry that you lost your database: http://about.gitlab.com/2017/02/01/gitlab-dot-com-database-incident/ Thank you for posting this publicly to allow us to comment on this for your postmortem analysis. I’m very happy that you monitor Replication Lag, that is good. Replication lag of 4GB is at times normal, so s

I’m pleased to say that Postgres-BDR is on its way to PostgreSQL 9.6, and even better, it works without a patched PostgreSQL. BDR has always been an extension, but on 9.4 it required a heavily patched PostgreSQL, one that isn’t fully on-disk-format compatible with stock community PostgreSQL 9.4. The goal all along has been to allow it to run as an extension on an unmodified PostgreSQL … and now we

A small peek into the future of what should be arriving for PostgreSQL 9.6. Today PostgreSQL took a big step ahead in the data warehouse world and we now are able to perform aggregation in parallel using multiple worker processes! This is great news for those of you who are running large aggregate queries over 10’s of millions or even billions of records, as the workload can now be divided up and

Sometimes SELECT pg_backend_pid() and gdb‘s attach aren’t enough. You might have a variable in shared memory that’s being changed by some unknown backend at some unknown time. Or a function that’s called from somewhere, but you don’t know where or when. I’ve recently been doing quite a bit of work on code where bgworkers launch other bgworkers, which launch more bgworkers. All of them communicate

Access our comprehensive knowledge base focused on security, privacy, and compliance.

I’ve seen a number of users struggling with building PostgreSQL extensions under Visual Studio, so I thought I’d see what’s involved in getting it working. The result is this tutorial, showing how to compile a simple extension with Visual Studio 2010 Express Edition. Requirements You will need a supported version of Visual Studio installed. These instructions refer to Visual Studio 2010 Express Ed

GridSQL Home | Architecture | FAQ | Forums GridSQL Open Source Project GridSQL is a shared-nothing clustered database system targeted at data warehousing and data mart applications. It includes intelligence to maximize parallelization over multiple servers, delivering faster query response times than can be achieved by single-node databases. GridSQL clusters together independent database nodes a