Skip site navigation (1) Skip section navigation (2)

Re: Abnormal performance difference between Postgres and MySQL

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Claus Guttesen <kometen(at)gmail(dot)com>
Cc: Farhan Husain <russoue(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Abnormal performance difference between Postgres and MySQL
Date: 2009-02-25 02:21:11
Message-ID: 603c8f070902241821j5d6dcb3au843f28d80e1c123@mail.gmail.com (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-performance by date

Next:From: Tomasz MyrtaDate: 2009-02-25 10:20:02
Subject: full text search - dictionary caching
Previous:From: Claus GuttesenDate: 2009-02-24 20:55:22
Subject: Re: Abnormal performance difference between Postgres and MySQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group