Igor Polishchuk
I'm working with databases for 15+ years, most of them as Oracle DBA. For the last 4 years, I'm specializing in Postgresql. Here, I collect my findings on databases, Linux, and related stuff. Hopefully, some of them may be useful for other people, too.
Author Archives: igorsf
PostgreSQL Developer’s Guide
Packt Publishing continues its line of good books on Postgresql. Their latest publication is ‘PostgreSQL Developer’s Guide‘ by Ibrar Ahmed, Asif Fayyaz, Amjad Shahzad http://bit.ly/1GO5eTd. Recently, a new developer asked me for a book on Postgresql as an introduction to that … Continue reading
Book review: PostgreSQL 9 High Availability Cookbook
PostgreSQL 9 High Availability Cookbook: Pact Publishing, 2014 As it happens with fiction literature, I did not quiet like this book from the very beginning, but it became interesting after the first chapter. So, if you read it cover to cover, … Continue reading
Book Review: Postgresql Replication
PostgreSQL Replication Paperback by Zoltan Böszörmenyi (Author) , Hans-Jürgen Schönig (Author) This is the link to the book: http://bit.ly/15DSxgi This book covers a variety of different replication solutions. It also very briefly covers some concepts not directly related to replication, … Continue reading
Posted in Database
Leave a comment
How to create pg_reorg v.1.1.7 rpm for Postgres 9.1
Here is an update to my recent post on creating pg_reorg 1.1.7 rpm. That previous post created rpm working with Postgres 9.0. Now, I need it working with Postgres 9.1. Also, the problem with the rpm created using the old … Continue reading
Posted in Database, Linux, Postgresql
Tagged DBA tools, Linux, PGWest 2011, pg_reorg, Postgresql, RPM, San Jose
Leave a comment
How to create pg_reorg v.1.1.7 rpm ( Additional material to my PG West 2011 presentation)
I’m making a presentation “pg_reorg – A Tool You Can’t Live Without” on PGWest 2011 conference in San Jose. Here is some additional material on pg_reorg for the people who would like to try the tool. pg_reorg used to be … Continue reading
Posted in Database, Linux, Postgresql
Tagged DBA tools, Linux, PGWest 2011, pg_reorg, Postgresql, RPM, San Jose
Leave a comment
Dealing with low free swap space issue
Recently, I’ve received a nagios alert “SWAP CRITICAL – 1% free (0 MB out of 1983 MB)” on one of my large batch processing hosts. The batch process finished, and nothing was happening on the host, but the swap space … Continue reading
Mount HDFS as a filesystem on Centos 5.6
The libhdfs library from project FUSE allows to mount HDFS as a filesystem. This is how I did it using Cloudera cdh3 hadoop distro on Centos 5.6 EC2 host. It’s so easy when it works 😉 First, install the necessary … Continue reading
pg_reorg – A Tool You Can’t Live Without
Below is the working material for my presentation about pg_reorg at the San Francisco Postgres Meetup on August 9, 2011 and PgWest 2011. Here are the actual slides with fewer words, but more pictures. What is pg_reorg? pg_reorg can re-organize … Continue reading
Posted in Database, Postgresql
Tagged clustering, online reorganization, pg_reorg, Postgresql, utilities, vacuum full
1 Comment
How I’ve got 5x more throughput on cheaper storage (compare DELL MD1200+H800 vs DELL MD3000+MD1000 or MD3220)
Recently, I’ve spent some time building new hosts for PowerReviews’ databases and benchmarking some Dell’s DAS arrays. These databases execute a lot of batch operations and need good sequential I/O throughput. I’ve setup a cheaper development and QA host in … Continue reading
Posted in Benchmarking, Database, HDD, Performance, Storage
Tagged benchmarking, Dell, performance, storage
16 Comments
Yahoo mail does not like Chrome anymore?
I was using Yahoo mail in Chrome browser on my Ubuntu host for quite a while. The “new” Yahoo mail always gave me a warning right after the login, something along the lines that my browser is not supported. However, … Continue reading
Igor Polishchuk's Blog 