Postgres Pro
Downloads
Home   >   mailing lists

Re: Abnormal performance difference between Postgres and MySQL - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Abnormal performance difference between Postgres and MySQL
Date
Msg-id dcc563d10902261116h65c7d570ob84c583112a6b50c@mail.gmail.com
Whole thread Raw
In response to Re: Abnormal performance difference between Postgres and MySQL  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-performance
Tree view 
On Thu, Feb 26, 2009 at 12:10 PM, Steve Clark <sclark@netwolves.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.

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Abnormal performance difference between Postgres and MySQL
Next
From: Steve Clark
Date:
Subject: Re: Abnormal performance difference between Postgres and MySQL