[PERFORM] Pgbench TPS Calculation

Hi, I am using pgbench for running tests on PostgreSQL. I have a few questions; 1) For calculating time to get the TPS, is pgbench using the wall clock time or cpu time? 2)How is TPS calculated? Thanks in advance, Reydan -- Sent via pgsql-performance mailing list (pgsql-performance@postgres

[PERFORM] pgbench installation

Hi All, I have compiled PostgreSQL 8.4 from source code and in order to install pgbench, I go under contrib folder and run below commands: make make install when I write pgbench as a command system cannot find pgbench as a command. As a result I cannot use pgbench-tools because system does not int

Re: [PERFORM] PostgreSQL on SMP Architectures

I want to do the second. I want to spread out the workload on all cores. But also I want to set the core number; for example first I want to spread out the workload to 32 cores then 64 cores and see the scalability. On Feb 14, 2010, at 8:25 PM, Scott Marlowe wrote: With all that info, your

[PERFORM] PostgreSQL on SMP Architectures

Hi, I have seen some work done about scaling PostgreSQL on SMP machines and see that PostgreSQL has been executed on several numbers of cores. I have some questions about scaling PostgreSQL on SMP architectures. System Details that I am running PostgreSQL-8.4.0: Server: HP Integrity Superdo

Re: [PERFORM] OpenMP in PostgreSQL-8.4.0

So I am trying to understand that can anyone rewrite some functions in postgresql with OpenMP in order to increase performance. does this work? On Nov 29, 2009, at 3:05 PM, Bruce Momjian wrote: Reydan Cankur wrote: You mean that backend does not support threading and everything I try is

Re: [PERFORM] OpenMP in PostgreSQL-8.4.0

: Reydan Cankur writes: I am trying to run postgresql functions with threads by using OpenMP. This is pretty much doomed to failure. It's *certainly* doomed to failure if you just hack up one area of the source code without dealing with the backend's general lack of support for

[PERFORM] OpenMP in PostgreSQL-8.4.0

Hi, I am trying to run postgresql functions with threads by using OpenMP. I tried to parallelize slot_deform_tuple function(src/backend/access/ common/heaptuple.c) and added below lines to the code. #pragma omp parallel { #pragma omp sections { #pragma omp sec

[PERFORM] Using OProfile

Hi, I tried to profile postgresql queries with OProfile but I could not do. OProfile version: 0.9.5 PostgreSQL version: 8.4.0 OS: CentOS 5 I compiled OProfile with "./configure --with-kernel-support", "make" and "make install"; also I created a user and a group both named as "oprofile". User

[PERFORM] Best Profiler for PostgreSQL

Hi, I am running PostgreSQL-8.4.0 on a SMP Server which has 32 processors (32X2=64 cores). I am working on database parallelism and I need to do profiling in order to find the relevant parts to parallelize. I wrote 15 queries which are performing select, sort, join, and aggregate function

Re: [PERFORM] Using Gprof with Postgresql

I just compiled it with gcc and produces the gmon.out file for every process; by the way I am running below script in order to produce readable .out files gprof .../pgsql/bin/postgres gmon.out > createtable2.out is postgres the right executable? regards reydan On Sep 7, 2009, at 8:24

Re: [PERFORM] Using Gprof with Postgresql

I just compiled it with gcc and produces the gmon.out file for every process; by the way I am running below script in order to produce readable .out files gprof .../pgsql/bin/postgres gmon.out > createtable2.out is postgres the right executable? regards reydan On Sep 7, 2009, at 8:24 PM,

[PERFORM] Using Gprof with Postgresql

Hi All, I compile PostgreSQL-8.4.0 with icc and --enable profiling option. I ran command psql and create table and make a select then I quit psql and go to .../data/gprof folder there are some folders named with numbers (I think they are query ids); all of them are empty. How can I solve