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

From Robert Haas
Subject Re: Abnormal performance difference between Postgres and MySQL
Date
Msg-id 603c8f070902251152s67ed8353v29f41f8e413e259d@mail.gmail.com
Whole thread Raw
In response to Re: Abnormal performance difference between Postgres and MySQL  (Farhan Husain <russoue@gmail.com>)
Responses Re: Abnormal performance difference between Postgres and MySQL
List pgsql-performance
> Please note that this (1792MB) is the highest that I could set for work_mem.

Yeah, that's almost certainly part of your problem.

You need to make that number MUCH smaller.  You probably want a value
like 1MB or 5MB or maybe if you have really a lot of memory 20MB.

That's insanely high.

...Robert

pgsql-performance by date:

Previous
From: Scott Carey
Date:
Subject: Re: PostgreSQL block size for SSD RAID setup?
Next
From: Scott Marlowe
Date:
Subject: Re: Abnormal performance difference between Postgres and MySQL