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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s