On Wed, Feb 25, 2009 at 12:49 PM, Robert Haas <robertmh...@gmail.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 <russ...@gmail.com> wrote: > > > > > > On Tue, Feb 24, 2009 at 8:21 PM, Robert Haas <robertmh...@gmail.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
