Hello All,
We are migrating our product from 32 bit CentOS version 5.0 (kernel 2.6.18) to
64 bit CentOS version 6.0 (kernel 2.6.32)
So we decided to upgrade the PostgreSQL version from 8.2.2 to 9.0.4
We are compiling the PostgreSQL source on our build machine to create an RPM
before using it in our product.
The issue we have noticed is the 9.0.4 (64 bit) version of PostgreSQL has
slower performance as compared to 8.2.2 (32 bit) version on an identical
hardware.
To investigate further we tried monitoring the PostgreSQL process using strace
and found that the earlier version of PostgreSQL was using _llseek() system
call whereas the later version is using lseek() system call.
Will this impact the PostgreSQL performance? When the timing is on we found
every query executed on 9.0.4 was taking longer than the query executed on 8.2.2
Please guide me what should I see while compiling the PostgreSQL 9.0.4 version
to improve its performance.
Thank you,
Umesh
