I have been gathering some statistics about each major PostgreSQL release. Here is the update for this year:
Some time ago, someone asked on a PostgreSQL mailing list whether there was a diagram of the PostgreSQL system catalogs. There wasn’t at the time. Something like that used to be included in the PostgreSQL documentation, but it was never updated, and so it was eventually removed.
One of the new features in PostgreSQL 15 is that you can use ICU collations on a database and instance level.
A little while ago, we had a few PostgreSQL hackers in a room and someone oversaw me typing something like
I seem to be doing this a lot:
When you are coding in a source tree as big as PostgreSQL’s, you will at some point want to look into some kind of source code indexing. It’s often convenient not to bother, since
git grepis actually superfast. But when you want to find where a function is defined among all the call sites, some more intelligence is useful.
Here are some tweaks to
git logthat I have found useful. It might depend on the workflow of individual projects how applicable this is.
I was idly wondering what was taking
pg_dumpso long and noticed that it always seemed to be pegged at 100% CPU usage on the client. That was surprising because naively one might think that the bottleneck are the server’s or the client’s disk or the network. Profiling quickly revealed that the compression library zlib was taking most of the run time on the client. And indeed, turning compression off caused
pg_dumpto fly without getting anywhere near 100% CPU.
So I had this PostgreSQL database that was getting a bit too big, and since it was really only for analytics, I figured it would be a good fit for putting in Hadoop+Hive instead.
About two months ago, this happened:
PgBouncer has a virtual database called
pgbouncer. If you connect to that you can run special SQL-like commands, for example
2001: PostgreSQL 7.1: write-ahead log
There is a lot of helpful information about
screenout there, but I haven’t found anything about this. I don’t want to “forget” any screen sessions, so I’d like to be notified when I log into a box and there are screens running for me. Obviously, there is
screen -ls, but it needs to be wrapped in a bit logic so that it doesn’t annoy when there is no
screenrunning or even installed.
Normally, this doesn’t work as one might naively expect:
This is my new blog. My old blog was here, but it was time to move on.
subscribe via RSS