On Wed, Feb 25, 2009 at 12:49 PM, Robert Haas <robertmhaas@xxxxxxxxx> 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@xxxxxxxxx> wrote:
>
>
> On Tue, Feb 24, 2009 at 8:21 PM, Robert Haas <robertmhaas@xxxxxxxxx> 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
