] Deterioration in performance when query executed in
multi threads
From: Anne Rosset [aros...@collab.net]
Sent: Monday, May 06, 2013 5:51 PM
To: Igor Neyman; k...@rice.edu
Cc: pgsql-performance@postgresql.org
Subject: RE: [PERFORM] Deterioration in performance when
From: Anne Rosset [aros...@collab.net]
Sent: Monday, May 06, 2013 5:51 PM
To: Igor Neyman; k...@rice.edu
Cc: pgsql-performance@postgresql.org
Subject: RE: [PERFORM] Deterioration in performance when query executed in
multi threads
Hi Igor,
Result with
ce-ow...@postgresql.org
[mailto:pgsql-performance-ow...@postgresql.org] On Behalf Of Thomas Kellerer
Sent: Monday, May 06, 2013 10:12 AM
To: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Deterioration in performance when query executed in
multi threads
Anne Rosset, 06.05.2013 19:00:
Pos
ser1439'::text))
Total runtime: 2666.011 ms
effective_cache_size| 512MB
Thanks,
Anne
-Original Message-
From: Igor Neyman [mailto:iney...@perceptron.com]
Sent: Monday, May 06, 2013 10:13 AM
To: Anne Rosset; k...@rice.edu
Cc: pgsql-performance@postgresql.org
Subject: RE:
Sent: Monday, May 06, 2013 10:12 AM
To: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Deterioration in performance when query executed in
multi threads
Anne Rosset, 06.05.2013 19:00:
> Postgres version: 9.0.13
>
>> Work_mem is set to 64MB
>> Shared_buffer to 240MB
> -Original Message-
> From: pgsql-performance-ow...@postgresql.org [mailto:pgsql-performance-
> ow...@postgresql.org] On Behalf Of Thomas Kellerer
> Sent: Monday, May 06, 2013 1:12 PM
> To: pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] Deterioration in perf
> -Original Message-
> From: Anne Rosset [mailto:aros...@collab.net]
> Sent: Monday, May 06, 2013 1:01 PM
> To: Igor Neyman; k...@rice.edu
> Cc: pgsql-performance@postgresql.org
> Subject: RE: [PERFORM] Deterioration in performance when query executed
> in multi
Anne Rosset, 06.05.2013 19:00:
Postgres version: 9.0.13
Work_mem is set to 64MB
Shared_buffer to 240MB
Segment_size is 1GB
Wal_buffer is 10MB
Artifact table: 251831 rows
Field_value table: 77378 rows
Mntr_subscription: 929071 rows
Relationship: 270478 row
Folder: 280356 rows
Item: 716465 rows
pgsql-performance@postgresql.org
Subject: RE: [PERFORM] Deterioration in performance when query executed in
multi threads
> -Original Message-
> From: Anne Rosset [mailto:aros...@collab.net]
> Sent: Friday, May 03, 2013 4:52 PM
> To: Igor Neyman; k...@rice.edu
> C
Hi all,
We are running a stress test that executes one select query with multiple
threads.
The query executes very fast (10ms). It returns 100 rows. I see deterioration
in the performance when we have multiple threads executing the query. With 100
threads, the query takes between 3s and 8s.
I
On Fri, May 3, 2013 at 3:52 PM, Anne Rosset wrote:
> We saw a little bit improvement by increasing the min_pool_size but again I
> see a bigvariation in the time the query is executed. Here is the query:
>
> srdb=> explain analyze SELECT
> psrdb->artifact.id AS id,
> psrdb->artifa
> -Original Message-
> From: Anne Rosset [mailto:aros...@collab.net]
> Sent: Friday, May 03, 2013 4:52 PM
> To: Igor Neyman; k...@rice.edu
> Cc: pgsql-performance@postgresql.org
> Subject: RE: [PERFORM] Deterioration in performance when query executed
> in multi
_mem is set to 64MB
Shared_buffer to 240MB
Segment_size is 1GB
Wal_buffer is 10MB
If you can give me some pointers, I would really appreciate.
Thanks,
Anne
-Original Message-
From: Igor Neyman [mailto:iney...@perceptron.com]
Sent: Wednesday, May 01, 2013 10:26 AM
To: Anne Rosset; k...
>
> Thanks,
> Anne
>
> -Original Message-
> From: k...@rice.edu [mailto:k...@rice.edu]
> Sent: Wednesday, May 01, 2013 9:27 AM
> To: Anne Rosset
> Cc: pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] Deterioration in performance when query executed
> in
: Wednesday, May 01, 2013 9:27 AM
To: Anne Rosset
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Deterioration in performance when query executed in
multi threads
On Wed, May 01, 2013 at 04:07:55PM +, Anne Rosset wrote:
> Hi Ken,
> Thanks for your answer. My test is actually runnin
On Wed, May 1, 2013 at 10:26 AM, k...@rice.edu wrote:
> On Wed, May 01, 2013 at 04:07:55PM +, Anne Rosset wrote:
>> Hi Ken,
>> Thanks for your answer. My test is actually running with jboss 7/jdbc and
>> the connection pool is defined with min-pool-size =10 and max-pool-size=400.
>>
>> Why w
On Wed, May 01, 2013 at 04:07:55PM +, Anne Rosset wrote:
> Hi Ken,
> Thanks for your answer. My test is actually running with jboss 7/jdbc and the
> connection pool is defined with min-pool-size =10 and max-pool-size=400.
>
> Why would you think it is an issue with the connection pool?
>
>
...@rice.edu]
Sent: Wednesday, May 01, 2013 7:13 AM
To: Anne Rosset
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Deterioration in performance when query executed in
multi threads
On Wed, May 01, 2013 at 02:05:06PM +, Anne Rosset wrote:
> Hi all,
> We are running a stress tes
On Wed, May 01, 2013 at 02:05:06PM +, Anne Rosset wrote:
> Hi all,
> We are running a stress test that executes one select query with multiple
> threads.
> The query executes very fast (10ms). It returns 100 rows. I see
> deterioration in the performance when we have multiple threads executi
Hi all,
We are running a stress test that executes one select query with multiple
threads.
The query executes very fast (10ms). It returns 100 rows. I see deterioration
in the performance when we have multiple threads executing the query. With 100
threads, the query takes between 3s and 8s.
I
20 matches
Mail list logo
