Just start up psql and type: show work_mem; (You could look in the config file too I suppose.) ...Robert On Wed, Feb 25, 2009 at 1:53 PM, Farhan Husain <russoue@xxxxxxxxx> wrote: > > > 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 > -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
