| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "John Allgood" <jallgood(at)the-allgoods(dot)net> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: High Load on Postgres 7.4.16 Server |
| Date: | 2007-04-06 05:50:51 |
| Message-ID: | 28405.1175838651@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
"John Allgood" <jallgood(at)the-allgoods(dot)net> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonathan Ellis | 2007-04-06 05:51:29 | Re: Premature view materialization in 8.2? |
| Previous Message | Tom Lane | 2007-04-06 05:43:16 | Re: Premature view materialization in 8.2? |