Re: High Load on Postgres 7.4.16 Server

From: Tom Lane
Subject: Re: High Load on Postgres 7.4.16 Server
Date: ,
Msg-id: 28405.1175838651@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: High Load on Postgres 7.4.16 Server  ("John Allgood")
List: pgsql-performance

Tree view

High Load on Postgres 7.4.16 Server  ("John Allgood", )
 Re: High Load on Postgres 7.4.16 Server  (Jeff Frost, )
  Re: High Load on Postgres 7.4.16 Server  ("John Allgood", )
   Re: High Load on Postgres 7.4.16 Server  (Jeff Frost, )
   Re: High Load on Postgres 7.4.16 Server  (Dave Cramer, )
    Re: High Load on Postgres 7.4.16 Server  ("John Allgood", )
     Re: High Load on Postgres 7.4.16 Server  (Dave Cramer, )
      Re: High Load on Postgres 7.4.16 Server  ("John Allgood", )
 Re: High Load on Postgres 7.4.16 Server  ("C. Bergström", )
 Re: High Load on Postgres 7.4.16 Server  (Tom Lane, )

"John Allgood" <> writes:
> ... The other configuration was RHEL3 and Postgres 7.4.13 and Redhat
> Cluster Suite. The application seemed to run much faster on the older
> equipment.

While I agree with the other comments that you should think about moving
to something newer than 7.4.x, there really shouldn't be any meaningful
performance difference between 7.4.13 and 7.4.16.  I'm guessing some
sort of pedestrian pilot error, like not using similar postgresql.conf
settings or forgetting to ANALYZE the database after reloading it into
the new installation.

            regards, tom lane


pgsql-performance by date:

From: Michael Stone
Date:
Subject: Re: SCSI vs SATA
From: Ron
Date:
Subject: Re: SCSI vs SATA