Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 24 Feb 2009 21:21:11 -0500
- Message-id: <603c8f070902241821j5d6dcb3au843f28d80e1c123@mail.gmail.com> <text/plain>
>> 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
- References:
- Abnormal performance difference between Postgres and MySQL
- From: Farhan Husain
- Re: Abnormal performance difference between Postgres and MySQL
- From: Claus Guttesen
- Re: Abnormal performance difference between Postgres and MySQL
- From: Farhan Husain
- Re: Abnormal performance difference between Postgres and MySQL
- From: Claus Guttesen
- Abnormal performance difference between Postgres and MySQL
- Prev by Date: Re: Abnormal performance difference between Postgres and MySQL
- Next by Date: full text search - dictionary caching
- Previous by thread: Re: Abnormal performance difference between Postgres and MySQL
- Next by thread: Re: Abnormal performance difference between Postgres and MySQL
- Indexes: