On 26 September 2012 19:09, FFW_Rude wrote:
> Could you explain what you are asking me to do because i don't really know
> what i'm doing...
postgresql-contrib packages contains pgbench tool on Ubuntu.
For example postgresql-contrib-9.1_9.1.3-2_i386.deb on Ubuntu 12.04 contains:
/usr/lib/postgre
On 26 September 2012 18:38, FFW_Rude wrote:
> root@testBI:/etc/postgresql/9.1/main# hdparm -tT /dev/sda
> Timing cached reads: 892 MB in 2.01 seconds = 444.42 MB/sec
> Timing buffered disk reads: 190 MB in 3.02 seconds = 62.90 MB/sec
It's OK for single HDD.
> Is fsync off by default ? I
Hi, FFW_Rude
1. Benchmark the device with your PostgreSQL DB:
# hdparm -tT /dev/sda
/dev/sda:
Timing cached reads: 6604 MB in 2.00 seconds = 3303.03 MB/sec
Timing buffered disk reads: 1316 MB in 3.00 seconds = 438.18 MB/sec
2. Benchmark your PostgreSQL with pgbench:
Set "fsync = off" on
Hi, Craig
On 14 September 2012 18:29, Craig James wrote:
> Did you compile the AMD code on the AMD system?
Yes
And it is optimized for Generic-x86-64 (CONFIG_GENERIC_CPU).
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http:
On 14 September 2012 11:45, Daniel Farina wrote:
> Did you tell LKML? It seems like a kind of change that could be found
> using git bisect of Linux, albiet laboriously.
Hi, Daniel
I sent it to linux-ker...@vger.kernel.org on Fri, 14 Sep 2012 10:47:44
+0300.
On 14 September 2012 17:56, Marcos
Hi
I compiled the 3.6-rc5 kernel with the same config from 3.5.3 and got
the 15-20% performance drop of PostgreSQL 9.2 on AMD chipsets (880G,
990X).
CentOS 6.3 x86_64
PostgreSQL 9.2
cpufreq scaling_governor - performance
# /etc/init.d/postgresql initdb
# echo "fsync = off" >> /var/lib/pgsql/data/
