Posts

Showing posts from June, 2011

history of email

Image
this is a lovely picture. its about invention of email how it comes till today.

java regex pipe problem

I was trying to split a string to an array. and the special character was | (pipe). String[] incomings=income.split("|"); and here is the out for income="abcd|efg" {"a","b","c","d","e","f","g"} then I understand that this pipe char turns this issue an regex one and doing some strange stuff :) after some research I found the solution. here is the solution for regex pipe incomings=income.split(Pattern.quote("|")); this makes the output for same situation like this: {"abcd","efg"} lovely

pg_dump and slowness

I am trying to make a backup of a very big postgresql(around 165 gb) for two days now. and at last I find out my mistake. never take a dump at same disk. it eats a lot of IO and kill all services which depends to dumped database. first try I am dumping database to same disk and after around 6 hours web server started to giving timeout and lovely sitescope mails :) and I had to kill that process. then I read a lot and started to dumping the database to another machine and it was smooth took around 4 hours to dump and no web server gave any timeout. example commands pg_dump -Fc dbname > db.backup and I started restore like this pg_restore -d dbname db.backup before that I needed to recreate the db from psql. and this have not finished I must tell that pg_restore has -j parameter which gives more thread to read the dump file and you can give cpu number to -j which will work faster.

öncelikle bloggerı terk etmek kolay değilmiş

neden derseniz sağlıklı güzel blog sistemi uraştırmıo çalışıo :) bide bundan sonra ingilizce geyikler yapıcam bilginize sunulur.