Re: Abnormal performance difference between Postgres and MySQL

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Steve Clark <sclark(at)netwolves(dot)com>
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Farhan Husain <russoue(at)gmail(dot)com>, Scott Carey <scott(at)richrelevance(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Abnormal performance difference between Postgres and MySQL
Date: 2009-02-26 19:16:54
Message-ID: dcc563d10902261116h65c7d570ob84c583112a6b50c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Feb 26, 2009 at 12:10 PM, Steve Clark <sclark(at)netwolves(dot)com> wrote:
>
> Can this be set in the postgresql.conf file?
> default_statistics_target = 50

Yep. It will take affect after a reload and after the current
connection has been reset.

If you want to you also set a default for a database or a role. Fine
tuning as needed.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Alexander Staubo 2009-02-27 20:18:42 Re: Bad plan for nested loop + limit
Previous Message Steve Clark 2009-02-26 19:10:29 Re: Abnormal performance difference between Postgres and MySQL