PostgreSQL
Window Functions example remix
The drawback of hosting a static only website is, obviously, the lack of comments. What happens actually, though, is that I receive very few comments by direct mail. As I …
category
PostgreSQL
133 posts
PostgreSQL
Window Functions example
So, when 8.4 came out there was all those comments about how getting window functions was an awesome addition. Now, it seems that a lot of people seeking for help in …
PostgreSQL
Synchronous Replication
Although the new asynchronous replication facility that ships with 9.0 ain’t released to the wide public yet, our hackers hero are already working on the …
PostgreSQL
Happy Numbers
After discovering the excellent Gwene service, which allows you to subscribe to newsgroups to read RSS content ( blogs, planets, commits, etc), I came to read this nice …
PostgreSQL
Playing with bit strings
The idea of the day ain’t directly from me, I’m just helping with a very thin subpart of the problem. The problem, I can’t say much about, let’s …
PostgreSQL
Editing constants in constraints
We’re using constants in some constraints here, for example in cases where several servers are replicating to the same federating one: each origin server has his …
PostgreSQL
Querying the Catalog to plan an upgrade
Some user on IRC was reading the releases notes in order to plan for a minor upgrade of his 8.3.3 installation, and was puzzled about potential needs for rebuilding GIST …
PostgreSQL
Database Virtual Machines
Today I’m being told once again about SQLite as an embedded database software. That one ain’t a database server but a software library that you can use …
PostgreSQL
Partitioning: relation size per “group”
This time, we are trying to figure out where is the bulk of the data on disk. The trick is that we’re using DDL partitioning, but we want a “nice” view of size per …
PostgreSQL
Background writers
There’s currently a thread on hackers about bg worker: overview and a series of 6 patches. Thanks a lot Markus! This is all about generalizing a concept already in …
PostgreSQL
Logs analysis
Nowadays to analyze logs and provide insights, the more common tool to use is pgfouine, which does an excellent job. But there has been some improvements in logs …
PostgreSQL
Using indexes as column store?
There’s a big trend nowadays about using column storage as opposed to what PostgreSQL is doing, which would be row storage. The difference is that if you have the …