Archiwizowane September, 2007

September 30th, 2007 by depesz | | 6 comments »

ci z was co mnie znają ciut bliżej wiedzą, że mam permanentne problemy finansowe. jakiś czas temu w mbanku wystąpiłem o kartę kredytową (jak chcesz skomentować: co za łoś, ma kłopoty finansowe i jeszcze kartę bierze, to sobie odpuść). mam u ...

just recently we got another array for out main production database. this means - we will be able to add new tablespace, thus making everything go faster. in theory - it's nice. but which tables to move to the other? the basic ...

September 30th, 2007 by depesz | Tags: | 1 comment »

svn directory analyze.pgsql.logs has been renamed to pgsql-tools. it still contains (and will contain) lgo analyzer, but now i will be able to put there more stuff :) current url: http://svn.depesz.com/svn/pgsql-tools/trunk.

for whatever reason i seem to remember names of files in postgresql documentation. for example - i know, that psql docs are in app-psql.html, base page for configuration options is runtime-config.html. manual for "alter table" sql command, is in sql-altertable.html. yet full ...

i recently got new toy for tests - brand new dell powervault md1000. what's this, you ask? basically - a rather nice das (direct attached storage) from dell. the box i got had 15 sas discs, each disc being 72gb, 15krpm. since this ...

there was this situation, that we had a lot of tables and a lot of update activity. so, we thought about splitting the most updated tables to parts that are usually stable, and parts (columns) which change often. but how to ...

September 20th, 2007 by depesz | Tags: | 3 comments »

all of you know copy command. it's fast for inserting new data. but can it be used it we want to insert or update rows? sure, it will be more than one command, but it's perfectly doable. here's how.

September 19th, 2007 by depesz | Tags: , | 4 comments »

cortilap @ freenode's #postgresql asked about how to create a check() that will allow only one of the columns to be not null. it doesn't sound cool, let's see: with 2 columns (a,b) you make a check: check ( (a is not ...

September 18th, 2007 by depesz | Tags: | 3 comments »

[ wersja polska poniżej ] english version just found this nice brain teaser. i have this code in bash: echo -e "1 1\n2 2" | while read A B; do echo "[$A] [$B]"; echo "ZZZ"; done it will print: [1] [1] ZZZ [2] [2] ZZZ which is perfectly valid and ...

September 17th, 2007 by depesz | Tags: | 7 comments »

this questions pops every once in a while on irc. some guy has a table, and it contains duplicated rows. basically there are 2 possible scenarios: all columns are duplicated only some columns are duplicated so, how to remove duplicates from such tables?