e answer to why Postgres is taking so
much time?
I can provide any other information needed and also 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 wrote:
> On Mon, Feb 23, 2009 at 4:16 PM, Farhan Husain wrote:
> > Hello,
> >
> > I am doing a performance comparison between running Jena with MySQL and
> > Postgres. I used the 8.3-community version of Postgres and MyS
On Mon, Feb 23, 2009 at 5:27 PM, Gregory Stark wrote:
> Farhan Husain 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
On Mon, Feb 23, 2009 at 5:27 PM, Gregory Stark wrote:
> Farhan Husain 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
On Mon, Feb 23, 2009 at 5:27 PM, Gregory Stark wrote:
> Farhan Husain 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
The result set should have 31 rows, that is correct.
On Mon, Feb 23, 2009 at 7:53 PM, Scott Marlowe wrote:
> On Mon, Feb 23, 2009 at 6:24 PM, Farhan Husain wrote:
> This sort here:
>
> >-> Sort (cost=565372.46..568084.16 rows=1084680 width=74) (actual
> > time=
|
> > Indexes:
> > "jena_g1t1_stmt_ixo" btree (obj)
> > "jena_g1t1_stmt_ixsp" btree (subj, prop)
>
> Isn't it missing an index on the column prop?
>
> select ... where A0.Prop='foo' and ...
>
> --
> regards
> Claus
>
> When lenity and cruelty play for a kingdom,
> the gentler gamester is the soonest winner.
>
> Shakespeare
>
Can you 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
On Wed, Feb 25, 2009 at 12:49 PM, Robert Haas 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 wrote:
> >
>
On Wed, Feb 25, 2009 at 12:58 PM, Robert Haas 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 wrote:
> >
> >
> >
; like 1MB or 5MB 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 amo
On Wed, Feb 25, 2009 at 3:30 PM, Robert Haas wrote:
> On Wed, Feb 25, 2009 at 3:44 PM, Farhan Husain 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
> resulted
On Wed, Feb 25, 2009 at 3:35 PM, Scott Marlowe wrote:
> On Wed, Feb 25, 2009 at 2:32 PM, Farhan Husain wrote:
> >
> > On Wed, Feb 25, 2009 at 3:30 PM, Robert Haas
> wrote:
> >>
> >> On Wed, Feb 25, 2009 at 3:44 PM, Farhan Husain
> wrote:
> >> >
system does without that setting. But
> changing shared_buffers will not change the plan, so let's not worry
> about that right now.
>
> ...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 wrote:
> On Wed, Feb 25, 2009 at 2:38 PM, Farhan Husain wrote:
> >
> >
> > On Wed, Feb 25, 2009 at 3:35 PM, Scott Marlowe
> > wrote:
> >>
> >> On Wed, Feb 25, 2009 at 2:32 PM, Farhan Husain
> wrot
think I understood what it said.
2009/2/25 Akos Gabriel
> Wed, 25 Feb 2009 15:43:49 -0600 -n
> Farhan Husain í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 shared_buff
On Wed, Feb 25, 2009 at 4:10 PM, Kevin Grittner wrote:
> >>> Farhan Husain 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, which would
On Wed, Feb 25, 2009 at 4:10 PM, Kevin Grittner wrote:
> >>> Farhan Husain 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, which would
efault to 20 to 40 and
> re-analyzing all the tables.
>
>
>
>
>
>
> On 2/25/09 3:11 PM, "Kevin Grittner" wrote:
>
> >>> Farhan Husain wrote:
> > Kevin Grittner >> >>> Farhan Husain wrote:
> >> > The machine postgres is runn
18 matches
Mail list logo
