select * from depesz;

Today we have two interesting patches:

• patch by Teodor Sigaev and Oleg Bartunov, and committed by Tom Lane, which adds interesting capability to GIN indexes
• patch by Zoltan Boszormenyi, also committed by Tom, which adds “RESTART” option to ALTER SEQUENCE. With some interesting consequences

- MORE -

couple of times is was brought to attention of #postgresql channel - how to find longest prefix.

case: you have phone number, and you want to find which carrier it is bound to.

there are at least 3 ways of finding it, and i decided to take a look at which is fastest.

- MORE -