Summary: I am facing a contention problem with ODBC on the client side. strace
and perf top show we are serializing over what appears to be accesses to the
ODBC statement handle. Contention goes down if I use multiple processes instead
of multiple threads within a process. Also, all the threads
etween the
TPC-E schema and the TPCx-V schema that running TPCx-V on a single VM doesn't
exactly take you to TPC-E.
Thanks,
Reza Taheri for the TPCx-V subcommittee
d procedures to see if I can execute the whole transaction in a
single stored procedure
Thanks,
Reza
> -Original Message-
> From: Craig Ringer [mailto:cr...@2ndquadrant.com]
> Sent: Sunday, July 27, 2014 8:58 PM
> To: Reza Taheri; pgsql-performance@postgresql.org
> Subje
Hi Ryan,
I just noticed that the mail alias manager has stalled the post below because
of the attachment size. But you should have gotten it directly.
If anyone else is interested in a copy, let me know, and I will forward it
Thanks,
Reza
> -Original Message-
> From: Reza Taheri
tgresql.org [mailto:pgsql-
> performance-ow...@postgresql.org] On Behalf Of Ryan Johnson
> Sent: Saturday, July 26, 2014 2:06 PM
> To: Reza Taheri
> Cc: pgsql-performance@postgresql.org
> Subject: Re: High rate of transaction failure with the Serializable Isolation
> Level
>
> Dre
From: pgsql-performance-ow...@postgresql.org [mailto:pgsql-
> performance-ow...@postgresql.org] On Behalf Of Ryan Johnson
> Sent: Friday, July 25, 2014 2:36 PM
> To: pgsql-performance@postgresql.org
> Subject: Re: High rate of transaction failure with the Serializable Isolation
> Level
>
n failure with the Serializable Isolation
> Level
>
> On 07/23/2014 06:18 PM, Reza Taheri wrote:
> > [By way of introduction, we are a TPC subcommittee that is developing
> > a benchmark with cloud-like characteristics for virtualized databases.
> > The end-to-end benchmarking kit
t. But when I start the axing process, they will be one of the first to go
Thanks,
Reza
> -Original Message-
> From: Craig Ringer [mailto:cr...@2ndquadrant.com]
> Sent: Thursday, July 24, 2014 6:30 PM
> To: Reza Taheri; pgsql-performance@postgresql.org
> Subject: Re: [PERFO
pred_locks_per_transaction = 6400
Thanks,
Reza
> -Original Message-
> From: Kevin Grittner [mailto:kgri...@ymail.com]
> Sent: Thursday, July 24, 2014 7:03 AM
> To: Reza Taheri; pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] High rate of transaction failure w
Hello PGSQL performance community,
[By way of introduction, we are a TPC subcommittee that is developing a
benchmark with cloud-like characteristics for virtualized databases. The
end-to-end benchmarking kit will be publicly available, and will run on PGSQL]
I am running into very high failure r
> Try setting the vm.dirty_bytes sysctl. Something like 256MB might be a good
> starting point.
>
> This comes up fairly often, see e.g.:
> http://www.postgresql.org/message-id/flat/27C32FD4-0142-44FE-8488-
> 9f366dc75...@mr-paradox.net
>
> - Heikki
Thanks, Heikki. That sounds like my problem al
Reza
> -Original Message-
> From: Merlin Moncure [mailto:mmonc...@gmail.com]
> Sent: Tuesday, July 10, 2012 12:06 PM
> To: Reza Taheri
> Cc: Greg Smith; pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] The need for clustered indexes to boost TPC-V
> performance
&
ll put our heads together
next week to see what version to use when I switch to a larger testbed I am
preparing.
Thanks,
Reza
From: Craig Ringer [mailto:ring...@ringerc.id.au]
Sent: Thursday, July 05, 2012 5:46 PM
To: Reza Taheri
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Th
f the high level details.
We need to see if we can use the draft clause to also release beta versions of
code.
Thanks,
Reza
> -Original Message-
> From: Craig Ringer [mailto:ring...@ringerc.id.au]
> Sent: Thursday, July 05, 2012 8:41 PM
> To: Reza Taheri
> Cc: Greg Smit
Hello PGSQL fans,
Looking back at my posts the past couple of days and the replies that I've got,
I realized that I have failed to make one point clear: we are very pleased with
what we have seen from PostgreSQL so far. Let me explain. At this point of
developing or porting a benchmark on a new
forward.
Thanks,
Reza
> -Original Message-
> From: Greg Smith [mailto:g...@2ndquadrant.com]
> Sent: Thursday, July 05, 2012 6:42 PM
> To: Reza Taheri
> Cc: pgsql-performance@postgresql.org; Andy Bond (ab...@redhat.com);
> Greg Kopczynski; Jignesh Shah
> Subject: Re: [
, and will take some work.
Cheers,
Reza
> -Original Message-
> From: Greg Smith [mailto:g...@2ndquadrant.com]
> Sent: Thursday, July 05, 2012 6:25 PM
> To: Reza Taheri
> Cc: pgsql-performance@postgresql.org; Andy Bond (ab...@redhat.com);
> Greg Kopczynski; Jignesh Shah
t the following message twice today with attachments (postgresql.conf,
etc.), and it hasn't been posted yet. Here it is without an attachment.
****
From: Reza Taheri
Sent: Thursday, July 05, 2012 11:34 AM
To: 'Craig Ringer'
C
el Gendler [mailto:sgend...@ideasculptor.com]
Sent: Thursday, July 05, 2012 12:46 PM
To: Reza Taheri
Cc: Robert Klemme; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] The need for clustered indexes to boost TPC-V performance
On Thu, Jul 5, 2012 at 12:13 PM, Reza Taheri
mailto:rtah...@vmware.com&g
Hi Robert,
Yes, the same concept. Oracle's IOT feature is used often with TPC benchmarks.
Thanks,
Reza
> -Original Message-
> From: Robert Klemme [mailto:shortcut...@googlemail.com]
> Sent: Thursday, July 05, 2012 5:30 AM
> To: Reza Taheri
> Cc: pgsql-performance@
Reza
> -Original Message-
> From: Daniel Farina [mailto:dan...@heroku.com]
> Sent: Wednesday, July 04, 2012 6:40 AM
> To: Craig Ringer
> Cc: Reza Taheri; pgsql-performance@postgresql.org; Robert Haas
> Subject: Re: [PERFORM] The need for clustered indexes to boost TPC-V
> perf
ced in
benchmarks and in database performance, but most of us are new to PGSQL.
Thanks,
Reza
> -Original Message-
> From: Craig Ringer [mailto:ring...@ringerc.id.au]
> Sent: Tuesday, July 03, 2012 10:19 PM
> To: pgsql-performance@postgresql.org
> Cc: Reza Taheri; Andy Bond (ab.
credible we are.
Sorry for the long post. I will follow up with specific questions next.
Thanks,
Reza Taheri
23 matches
Mail list logo
