December 18th, 2013 by depesz | Tags: , , , , , , | No comments »

Right after releasing 1.3.0 I realized that I forgot about one thing. If you're using ext3 (and possibly other, not sure) file system, removal of large file can cause problems due to heavy IO traffic. We did hit this problem earlier at ...

Question from title sounds weird to you? It's just a 'rm backup_filename'? Well. I really wish it was so simple in some cases. One of the servers I'm looking into, there is interesting situation: quite busy database server (2k tps is the ...

February 10th, 2009 by depesz | Tags: , , , , , , , | 4 comments »

I was lately writing some program for a client of mine, which used UPC codes matching. Since the codes are given in various ways, there was decision to pad the codes with leading zeros - up to 12 characters. The code has ...

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 ...

March 28th, 2008 by depesz | Tags: , , , , , , | 4 comments »

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).