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 603c8f070902241821j5d6dcb3au843f28d80e1c123@mail.gmail.com
Whole thread Raw
In response to Re: Abnormal performance difference between Postgres and MySQL  (Claus Guttesen <kometen@gmail.com>)
List pgsql-performance
>> Can you please elaborate a bit?
>
> I thought that A0.Prop would ignore the composite index created on the
> columns subj and prop but this does not seem to be the case.

Yeah, I think you're barking up the wrong tree here.  I think Tom had
the correct diagnosis - what do you get from "show work_mem"?

What kind of machine are you running this on?  If it's a UNIX-ish
machine, what do you get from "free -m"and "uname -a"?

...Robert

pgsql-performance by date:

Previous
From: Claus Guttesen
Date:
Subject: Re: Abnormal performance difference between Postgres and MySQL
Next
From: Tomasz Myrta
Date:
Subject: full text search - dictionary caching