Re: Abnormal performance difference between Postgres and MySQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Farhan Husain <russoue@xxxxxxxxx>
Subject: Re: Abnormal performance difference between Postgres and MySQL
From: Claus Guttesen <kometen@xxxxxxxxx>
Date: Wed, 25 Feb 2009 22:39:56 +0100
Cc: Robert Haas <robertmhaas@xxxxxxxxx>, pgsql-performance@xxxxxxxxxxxxxx
In-reply-to: <3df32b6d0902251105n359cd198y3bfda1113ab1d6fb@xxxxxxxxxxxxxx>
References: <3df32b6d0902231516r5ee558c8na8f78682e01e6207@xxxxxxxxxxxxxx> <b41c75520902232328s2321af46sa4193c89603232c9@xxxxxxxxxxxxxx> <3df32b6d0902241152h28909b2dy42d1bcf660e912ca@xxxxxxxxxxxxxx> <b41c75520902241255k678922c8med6e0028a51bb39e@xxxxxxxxxxxxxx> <603c8f070902241821j5d6dcb3au843f28d80e1c123@xxxxxxxxxxxxxx> <3df32b6d0902251034w19020e37ic2d8eab9b561be83@xxxxxxxxxxxxxx> <603c8f070902251049j7cf7757ao667357a83cf830a6@xxxxxxxxxxxxxx> <3df32b6d0902251053h292b3477h347ed06d0244b86e@xxxxxxxxxxxxxx> <603c8f070902251058j71e58c12wa9ad4a56d0d4a60e@xxxxxxxxxxxxxx> <3df32b6d0902251105n359cd198y3bfda1113ab1d6fb@xxxxxxxxxxxxxx>

What is random_page_cost set to? You could try to lower it to 1.5 if set higher.

-- 
regards
Claus

When lenity and cruelty play for a kingdom,
the gentler gamester is the soonest winner.

Shakespeare

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

References:
- Abnormal performance difference between Postgres and MySQL
  - From: Farhan Husain
- Re: Abnormal performance difference between Postgres and MySQL
  - From: Claus Guttesen
- Re: Abnormal performance difference between Postgres and MySQL
  - From: Farhan Husain
- Re: Abnormal performance difference between Postgres and MySQL
  - From: Claus Guttesen
- Re: Abnormal performance difference between Postgres and MySQL
  - From: Robert Haas
- Re: Abnormal performance difference between Postgres and MySQL
  - From: Farhan Husain
- Re: Abnormal performance difference between Postgres and MySQL
  - From: Robert Haas
- Re: Abnormal performance difference between Postgres and MySQL
  - From: Farhan Husain

Prev by Date: Re: Abnormal performance difference between Postgres and MySQL
Next by Date: Re: Abnormal performance difference between Postgres and MySQL
Previous by thread: Re: Abnormal performance difference between Postgres and MySQL
Next by thread: planner's midjudge number of rows resulting, despite pretty obvious join
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]