search for: pgbench

...10GB fileset, in MB/s: ext3 jfs xfs Read 112 188 141 Write 97 157 167 Rewrite 51 71 60 These number were obtained using the mkfs defaults for all filesystems and the deadline scheduler. As you can see JFS is kicking butt on this test. Next I used pgbench to test parallel random I/O. pgbench has configurable number of clients and transactions per client, and can change the size of its database. I used a database of 100 million tuples (scale factor 1000). I times 100,000 transactions on each filesystem, with 10 and 100 clients per run. Figures ar...

...Teresa, Thank you for your reply! I discussed this with Aditya and Rodrigo today about this. We will always have PGO turned on for our benchmark, (i.e. we assume the profiling information is always available). In terms of the workload we supply to PGO: For postgresql, I suggested we use the "pgbench" benchmark, a TPC-B-based SQL benchmark for postgres, to supply profiling information for PGO. We can use other workloads/benchmarks should you have any other suggestions about this. Thank you, Ruijie Ruijie Fang Email: ruijief at princeton.edu On Mon, Jun 1, 2020 at 11:28 AM Teresa Johns...

...r reply! I discussed this with Aditya and Rodrigo today >> about this. We will always have PGO turned on for our benchmark, (i.e. we >> assume the profiling information is always available). In terms of the >> workload we supply to PGO: For postgresql, I suggested we use the "pgbench" >> benchmark, a TPC-B-based SQL benchmark for postgres, to supply profiling >> information for PGO. We can use other workloads/benchmarks should you have >> any other suggestions about this. >> >> Thank you, >> Ruijie >> >> Ruijie Fang >>...

For a high-performance system (64-cores, 512GB RAM, 5TB local disk, 110TB NFS-mounted storage) is there any advantage of dropping lvm and mounting partitions directly? We're not planning on changing partition sizes, but if we did we'd probably do a full rebuild. Has anyone done performance testing to show that lvm isn't crippling I/O? Thanx, Russell

Hello, I am Ruijie Fang, a GSoC student working on "Improve hot cold splitting to aggressively outline small blocks." Over the course of last week, I met with my mentor and co-mentor, Aditya Kumar, and Rodrigo Rocha, and we made a preliminary plan on improving the existing hot/cold splitting pass in LLVM through identifying patterns of cold blocks in real-world workloads via block

...z CPU with 8 core , 64GB RAM BASE BASE+patch %improvement mean (sd) mean (sd) case 1x: 38.1033 (43.502) 38.09 (43.4269) 0.0349051 case 2x: 778.622 (1092.68) 129.342 (156.324) 83.3883 case 3x: 2399.11 (3548.32) 114.913 (139.5) 95.2102 2) pgbench: pgbench version: http://www.postgresql.org/ftp/snapshot/dev/ tool used for benchmarking: git://git.postgresql.org/git/pgbench-tools.git Ananlysis is done using ministat. Test is done for 1x overcommit to check overhead of pv spinlock. There is small performance penalty in non contention scenario (...

...z CPU with 8 core , 64GB RAM BASE BASE+patch %improvement mean (sd) mean (sd) case 1x: 38.1033 (43.502) 38.09 (43.4269) 0.0349051 case 2x: 778.622 (1092.68) 129.342 (156.324) 83.3883 case 3x: 2399.11 (3548.32) 114.913 (139.5) 95.2102 2) pgbench: pgbench version: http://www.postgresql.org/ftp/snapshot/dev/ tool used for benchmarking: git://git.postgresql.org/git/pgbench-tools.git Ananlysis is done using ministat. Test is done for 1x overcommit to check overhead of pv spinlock. There is small performance penalty in non contention scenario (...

...--with-ecj-jar=/usr/share/java/eclipse-ecj.jar --disable-libjava-multilib --with-ppl --with-cloog --with-tune=generic --with-arch_32=i686 --build=x86_64-redhat-linux Thread model: posix gcc version 4.4.5 20110214 base kernel = 3.3-rc6 (cloned sunday 4th march) unit=tps (higher is better) benchmak=pgbench based on pgsql 9.2-dev: http://www.postgresql.org/ftp/snapshot/dev/ (link given by Attilo) tool used to collect benachmark: git://git.postgresql.org/git/pgbench-tools.git config is same as tools default except MAX_WORKER=8 Average taken over 10 iterations, analysed with ministat tool. BASE (C...

...--with-ecj-jar=/usr/share/java/eclipse-ecj.jar --disable-libjava-multilib --with-ppl --with-cloog --with-tune=generic --with-arch_32=i686 --build=x86_64-redhat-linux Thread model: posix gcc version 4.4.5 20110214 base kernel = 3.3-rc6 (cloned sunday 4th march) unit=tps (higher is better) benchmak=pgbench based on pgsql 9.2-dev: http://www.postgresql.org/ftp/snapshot/dev/ (link given by Attilo) tool used to collect benachmark: git://git.postgresql.org/git/pgbench-tools.git config is same as tools default except MAX_WORKER=8 Average taken over 10 iterations, analysed with ministat tool. BASE (C...

This series replaces the existing paravirtualized spinlock mechanism with a paravirtualized ticketlock mechanism. The series provides implementation for both Xen and KVM.(targeted for 3.5 window) Note: This needs debugfs changes patch that should be in Xen / linux-next https://lkml.org/lkml/2012/3/30/687 Changes in V8: - Reabsed patches to 3.4-rc4 - Combined the KVM changes with ticketlock

This series replaces the existing paravirtualized spinlock mechanism with a paravirtualized ticketlock mechanism. The series provides implementation for both Xen and KVM.(targeted for 3.5 window) Note: This needs debugfs changes patch that should be in Xen / linux-next https://lkml.org/lkml/2012/3/30/687 Changes in V8: - Reabsed patches to 3.4-rc4 - Combined the KVM changes with ticketlock