PostgreSQL and Kernel 2.6.x

-
Kernel 2.6.x was what I was waiting to deploy with PostgreSQL, on a production server. The reason is quite obvious are
  1. The I/O improvements
    For me I/O is most important as that is what a database needs. With higher I/O rates the read write operation would be faster, thus reducing the query over head. Though I have not come across any benchmark which justifies my fantasy but that is what my tech head allows me to believe.
  2. Newer X server which would run much faster.
    This is another aspect as the server and client works on the same system. With front end running and db calls on the same server X server performance do helps.
  3. IPv6 is on by default thus I disabled it as
    As root in the end of /etc/modprobe.conf file.
    alias net-pf-10 off
    alias ipv6 off
    This helped as initialization time now was lesser.
To sum all I did not run any benchmarks which had before and after specs. But sheer logic says kernel 2.6.x would make PostgreSQL much faster. Would Post more after noticing the changes further.

Comments

Post a Comment

Popular posts from this blog

Language

-
I wrote this poem at a time when I was struggling for answers in my life. These questions are so intricate that it would fail great scholars and most learned of all and no book would talk about it. Then you turn to the supreme being and ask your questions silence comes in reply. You wait and wait more for an answer and then you are agitated and start complaining. Why does he not answer ? This leads to a moment of introspection and a spark arises that make you wonder of  the language to converse with almighty , Its then That I say .... . Talking to you is a problem to me, As I don't know the language of thee, English or Hindi wonder I in silence of me, Do these language pleases you my lee, No! Says the creator of me, Nor do I listen to Hindi or to English, I listen to thy heart beat in silence of me, So let your heart beat from lup-dup lup-dup to love-love love-love.
Read more

Could Russian and Venezuelan navy joint exercise, speed-up the slowing world economy.

-
You may call it hypothesis or upcoming fact. Collectively world war II and Cold war are known for an era when most inventions and innovations materialized. This was the time when money was pumped into various projects, just to keep the name of nation. Classic example would be space exploration. Not only this the same era called for heavy investments into research and development at defense front. Later defense projects found way into civilian life. Isn't computers network result of such project at DoD. Hope Russians splashing water in America's backyard. Would trigger another cold war. That would lead to chain reaction of funding defense, or may be implementation of missile umbrella on America. Thus Americans pumping more money into market which may lead to easy cash availability. This might give an impetus to slowing world economy.
Read more

Expressing gratitude

-
Never forget and lose a chance to thank people who have actually helped one to rise, with this though I thanked LINUX For You people today, these people acknowledged and published about SaiPACS , which indeed became a life time achievement for me. With lord's wish and will I got the thought of thanking these people. Today I feel relieved after expressing gratitude to Ms. and her team for all they have done for me , though it was her greatness that she found sense of duty in all they have done for me and Linux community.
Read more