On Wed, Feb 25, 2009 at 4:10 PM, Kevin Grittner kevin.gritt...@wicourts.gov
wrote:
Farhan Husain russ...@gmail.com wrote:
The machine postgres is running on has 4 GB of RAM.
In addition to the other suggestions, you should be sure that
effective_cache_size is set to a reasonable value
:
Farhan Husain russ...@gmail.com wrote:
Kevin Grittner kevin.gritt...@wicourts.gov wrote:
Farhan Husain russ...@gmail.com wrote:
The machine postgres is running on has 4 GB of RAM.
In addition to the other suggestions, you should be sure that
effective_cache_size is set to a reasonable
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 Wed, Feb 25, 2009 at 12:58 PM, Robert Haas robertmh...@gmail.com wrote:
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 russ...@gmail.com wrote:
On Wed, Feb 25, 2009 at 12:49
or maybe if you have really a lot of memory 20MB.
That's insanely high.
...Robert
Initially, it was the default value (32MB). Later I played with that value
thinking that it might improve the performance. But all the values resulted
in same amount of time.
--
Mohammad Farhan Husain
Research
On Wed, Feb 25, 2009 at 3:30 PM, Robert Haas robertmh...@gmail.com wrote:
On Wed, Feb 25, 2009 at 3:44 PM, Farhan Husain russ...@gmail.com wrote:
Initially, it was the default value (32MB). Later I played with that
value
thinking that it might improve the performance. But all the values
On Wed, Feb 25, 2009 at 3:35 PM, Scott Marlowe scott.marl...@gmail.comwrote:
On Wed, Feb 25, 2009 at 2:32 PM, Farhan Husain russ...@gmail.com wrote:
On Wed, Feb 25, 2009 at 3:30 PM, Robert Haas robertmh...@gmail.com
wrote:
On Wed, Feb 25, 2009 at 3:44 PM, Farhan Husain russ...@gmail.com
.
...Robert
--
Mohammad Farhan Husain
Research Assistant
Department of Computer Science
Erik Jonsson School of Engineering and Computer Science
University of Texas at Dallas
On Wed, Feb 25, 2009 at 3:55 PM, Scott Marlowe scott.marl...@gmail.comwrote:
On Wed, Feb 25, 2009 at 2:38 PM, Farhan Husain russ...@gmail.com wrote:
On Wed, Feb 25, 2009 at 3:35 PM, Scott Marlowe scott.marl...@gmail.com
wrote:
On Wed, Feb 25, 2009 at 2:32 PM, Farhan Husain russ
think I understood what it said.
2009/2/25 Akos Gabriel akos.gabr...@i-logic.hu
Wed, 25 Feb 2009 15:43:49 -0600 -n
Farhan Husain russ...@gmail.com írta:
OK, you have two options:
1. Learn to read carefully, and differentiate between work_mem and
shared_buffers options. Lower work_mem and rise
On Wed, Feb 25, 2009 at 4:10 PM, Kevin Grittner kevin.gritt...@wicourts.gov
wrote:
Farhan Husain russ...@gmail.com wrote:
The machine postgres is running on has 4 GB of RAM.
In addition to the other suggestions, you should be sure that
effective_cache_size is set to a reasonable value
The result set should have 31 rows, that is correct.
On Mon, Feb 23, 2009 at 7:53 PM, Scott Marlowe scott.marl...@gmail.comwrote:
On Mon, Feb 23, 2009 at 6:24 PM, Farhan Husain russ...@gmail.com wrote:
This sort here:
- Sort (cost=565372.46..568084.16 rows=1084680 width=74) (actual
please elaborate a bit?
Thanks,
--
Mohammad Farhan Husain
Research Assistant
Department of Computer Science
Erik Jonsson School of Engineering and Computer Science
University of Texas at Dallas
the data if anyone
wants.
Thanks and regards,
--
Mohammad Farhan Husain
Research Assistant
Department of Computer Science
Erik Jonsson School of Engineering and Computer Science
University of Texas at Dallas
On Mon, Feb 23, 2009 at 5:27 PM, Scott Marlowe scott.marl...@gmail.comwrote:
On Mon, Feb 23, 2009 at 4:16 PM, Farhan Husain russ...@gmail.com wrote:
Hello,
I am doing a performance comparison between running Jena with MySQL and
Postgres. I used the 8.3-community version of Postgres
On Mon, Feb 23, 2009 at 5:27 PM, Gregory Stark st...@enterprisedb.comwrote:
Farhan Husain russ...@gmail.com writes:
I can provide any other information needed and also the data if anyone
wants.
What did the query plans look like in both databases?
In Postgres you can get the query plan
On Mon, Feb 23, 2009 at 5:27 PM, Gregory Stark st...@enterprisedb.comwrote:
Farhan Husain russ...@gmail.com writes:
I can provide any other information needed and also the data if anyone
wants.
What did the query plans look like in both databases?
In Postgres you can get the query plan
On Mon, Feb 23, 2009 at 5:27 PM, Gregory Stark st...@enterprisedb.comwrote:
Farhan Husain russ...@gmail.com writes:
I can provide any other information needed and also the data if anyone
wants.
What did the query plans look like in both databases?
In Postgres you can get the query plan
18 matches
Mail list logo
