Tom Lane committed his patch which modifies output of “EXPLAIN VERBOSE" command.
Category: Uncategorized
do you know crontab?
simple brainteaser. take no more than 30 seconds to think about it:
using standard cron installed on your unix system, how often would this command be run:
*/57 * * * * command
? if you choose to answer in comments, please supply version of cron that your system is using.
My take on trees in SQL
Quick note in polish: jeśli znasz moje poprzednie posty nt. drzew, to ten możesz sobie pewnie odpuścić. będzie zawierał jedynie opis implementacji zbliżony do tego co już jest dostępne.
OK, back to English (or at least my version of English).
Finding a good way to store trees in SQL was/is my long-term hobby. I tried ltree, basic adjacency list, Celko's nested sets way, and nothing really was able to make me feel satisfied.
Ltree is great, but PostgreSQL only (not that it's a big problem). Adjacency list is very simple in insert, update and delete operations, but forces me to use recursive queries in case of some not-so-standard queries. Nested sets are quite the contrary – great for selects, but I simply hate writing insert/update/delete to these trees.
Is there anything better? I think so.
postgresql @ highscalability.com
as you perhaps know there is this site/blog called high scalability. it contains articles about various things related to performance, scalability, availability and so on.
usually, when there is something about databases, it is about mysql. luckily for us, today they showed something about postgresql:
waiting for 8.4 – current_query()
unfrotunatelly i can't point you to message in archives, as there is some problem with them, and i dont see posts newer than “Fri Apr 04 12:00:08 2008".
this patch was written by tomas doran, and commited by bruce momjian:
waiting for 8.4
another very interesting addon. pavel stehule wrote, and tom lane commited “execute using" in plpgsql.
waiting for 8.4
in today “waiting for 8.4" i will show you 3 new patches. all of them add new functionality to psql – the most common tool to access postrgesql database.
keyboard shortcuts in psql
there is this quite old, but pretty functional concept: keyboard shortcuts.
you know it – you press ctrl-s, and your editor saves currently-edited file.
my problem is that there are some standard cases when i would really love to have this ability in psql. but psql doesn't support it. or does it?
using separate environments for people using single account
there is this situation: multiple people have to have access to single system account on unix/linux.
you are one of them, but you really want to have your own environment. aliases, path, and so on.
problem? others dont want your changes. is it a lost case?
Continue reading using separate environments for people using single account
waiting for 8.4
another new, cool feature commited by tom lane: “Support statement-level ON TRUNCATE triggers."
original patch was submitted by simon riggs, and tom commited it today/yesterday (depending on time zone).