Re: Abnormal performance difference between Postgres and MySQL

On Wed, Feb 25, 2009 at 12:49 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:

> You still haven't answered the work_mem question, and you probably
> want to copy the list, rather than just sending this to me.
>
> ...Robert
>
> On Wed, Feb 25, 2009 at 1:34 PM, Farhan Husain <russoue(at)gmail(dot)com> wrote:
> >
> >
> > On Tue, Feb 24, 2009 at 8:21 PM, Robert Haas <robertmhaas(at)gmail(dot)com>
> wrote:
> >>
> >> >> 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
> >
> > Here is the machine info:
> >
> > Machine: SunOS 5.10 Generic_127111-11 sun4u sparc SUNW, Sun-Fire-880
> > Memory: 4 GB
> > Number of physical processors: 2
> >
> >
> > --
> > Mohammad Farhan Husain
> > Research Assistant
> > Department of Computer Science
> > Erik Jonsson School of Engineering and Computer Science
> > University of Texas at Dallas
> >
>

Did you mean the work_mem field in the config file?

--
Mohammad Farhan Husain
Research Assistant
Department of Computer Science
Erik Jonsson School of Engineering and Computer Science
University of Texas at Dallas