Archiwizowane March, 2010

One database that I am monitoring uses a lot of stored procedures. Some of them are fast, some of them are not so fast. I thought - is there a sensible way to diagnose which part of stored procedure take ...

There are several approaches on replication/failover - you might have heard of Slony, Londiste, pgPool and some other tools. WAL Replication is different from all of them in one aspect - it doesn't let you query slave database (until 9.0, in ...

Dynamic updates of fields in NEW in PL/pgSQL Today, on #postgresql on IRC, strk asked about updating fields in NEW record, in plpgsql, but where name of the field is in variable. After some time, he sent his question to hackers mailing ...

One common problem that a lot of people seem to have is when they encounter error message like this: # \i test.sql psql:test.sql:1: ERROR: invalid byte sequence for encoding "UTF8": 0xb3 Why it happens? What can be done about it? Let's ...

Fight! But more seriously - people tend to use various data types, and there have been some myths about them, so let's see how it really boils down. First of all - All those data types are internally saved using the same ...