On Sun, Sep 16, 2012 at 12:48 AM, Umesh Kirdat <umesh.kirdat@xxxxxxxxx> wrote: > 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. First of all, that's comparing apples and oranges. Compare the same version in 32-vs-64, and different versions on same-arch. > 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. Second, I doubt that's the problem. It's most likely increase memory footprint due to 64-bit pointers, a known overhead of the 64-bit arch, but a price you have to pay if you want access to more than 3-4GB of RAM. You'll be better off using a profiler, like oprofile, and compare the profile between the two arches. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
