Re: Abnormal performance difference between Postgres and MySQL

From: Claus Guttesen <kometen(at)gmail(dot)com>
To: Farhan Husain <russoue(at)gmail(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Abnormal performance difference between Postgres and MySQL
Date: 2009-02-25 21:39:56
Message-ID: b41c75520902251339x590c43acqb581068ae68ba562@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Haas 2009-02-25 21:40:19 Re: Abnormal performance difference between Postgres and MySQL
Previous Message Farhan Husain 2009-02-25 21:38:10 Re: Abnormal performance difference between Postgres and MySQL