[PERFORM] debug_assertions is enabled in official 9.6rc1 build

Hi *, just installed official rpm from http://yum.postgresql.org/ to check functionality and performance of 9.6rc1. Unfortunately, binaries are compiled with debug_assertions=on, which makes any performance testing useless. Regards, Tigran. -- Sent via pgsql-performance mailing list

Re: [PERFORM] Tuning guidelines for server with 256GB of RAM and SSDs?

Hi, We had a similar situation and the best performance was with 64MB background_bytes and 512 MB dirty_bytes. Tigran. On Jul 5, 2016 16:51, Kaixi Luo wrote:Hello,I've been reading Mr. Greg Smith's "Postgres 9.0 - High Performance" book and I have some questions regarding

Re: [PERFORM] New server: SSD/RAID recommendations?

Thanks for the Info. So if RAID controllers are not an option, what one should use to build big databases? LVM with xfs? BtrFs? Zfs? Tigran. - Original Message - From: Graeme B. Bell graeme.b...@nibio.no To: Steve Crawford scrawf...@pinpointresearch.com Cc: Wes Vaske (wvaske)

Re: [PERFORM] New server: SSD/RAID recommendations?

- Original Message - From: Graeme B. Bell graeme.b...@nibio.no To: Mkrtchyan, Tigran tigran.mkrtch...@desy.de Cc: Graeme B. Bell graeme.b...@nibio.no, Steve Crawford scrawf...@pinpointresearch.com, Wes Vaske (wvaske) wva...@micron.com, pgsql-performance pgsql-performance

Re: [PERFORM] 9.5alpha1 vs 9.4

On Jul 6, 2015 18:45, Josh Berkus j...@agliodbs.com wrote: On 07/05/2015 10:16 AM, Mkrtchyan, Tigran wrote: Thanks for the hin. My bad. The backup db and 9.5 had a different type on one of the foreign-key constrains char(36) vs varchar(36). The schema was screwed couple of days ago

Re: [PERFORM] 9.5alpha1 vs 9.4

0.01 |0.01 | 1006 | DELETE FROM t_dirs WHERE iname=$1 AND iparent=$2 0.00 |0.00 | 2004 | COMMI Tigran. - Original Message - From: Mkrtchyan, Tigran tigran.mkrtch...@desy.de To: pgsql-performance pgsql-performance@postgresql.org Sent: Sunday, July

[PERFORM] 9.5alpha1 vs 9.4

Hi, today I have update my test system to 9.5alpha1. Most of the operations are ok, except delete. I get ~1000 times slower! chimera=# SELECT (total_time / 1000 )::numeric(10,2) as total_secs, (total_time/calls)::numeric(10,2) as average_time_ms, calls, query FROM pg_stat_statements

Re: [PERFORM] 9.5alpha1 vs 9.4

- From: Tom Lane t...@sss.pgh.pa.us To: Andres Freund and...@anarazel.de Cc: Mkrtchyan, Tigran tigran.mkrtch...@desy.de, pgsql-performance pgsql-performance@postgresql.org Sent: Sunday, July 5, 2015 4:33:25 PM Subject: Re: [PERFORM] 9.5alpha1 vs 9.4 Andres Freund and...@anarazel.de

Re: [PERFORM] Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL

Hi Pietro, The modern CPUs trying to be too smart. try to run this code to disable CPUs c-states: setcpulatency.c #include stdio.h #include fcntl.h #include stdint.h int main(int argc, char **argv) { int32_t l; int fd; if (argc != 2) { fprintf(stderr, Usage: %s latency

Re: [PERFORM] postgres 9.3 vs. 9.4

...@catalyst.net.nz, postgres performance list pgsql-performance@postgresql.org Sent: Tuesday, September 23, 2014 4:21:13 PM Subject: Re: [PERFORM] postgres 9.3 vs. 9.4 On Tue, Sep 23, 2014 at 7:58 AM, Mkrtchyan, Tigran tigran.mkrtch...@desy.de wrote: Hi Merlin, you are right, in 9.4

Re: [PERFORM] postgres 9.3 vs. 9.4

tigran.mkrtch...@desy.de, Merlin Moncure mmonc...@gmail.com Cc: postgres performance list pgsql-performance@postgresql.org Sent: Wednesday, September 24, 2014 12:04:12 PM Subject: Re: [PERFORM] postgres 9.3 vs. 9.4 On 24/09/14 21:23, Mkrtchyan, Tigran wrote: Hi Merlin et al. after building

Re: [PERFORM] postgres 9.3 vs. 9.4

-performance@postgresql.org Sent: Monday, September 22, 2014 3:37:50 PM Subject: Re: [PERFORM] postgres 9.3 vs. 9.4 On Fri, Sep 19, 2014 at 6:58 PM, Mark Kirkwood mark.kirkw...@catalyst.net.nz wrote: On 19/09/14 19:24, Mkrtchyan, Tigran wrote: - Original Message - From

Re: [PERFORM] postgres 9.3 vs. 9.4

] postgres 9.3 vs. 9.4 On 19/09/14 17:53, Mkrtchyan, Tigran wrote: - Original Message - From: Mark Kirkwood mark.kirkw...@catalyst.net.nz Further to the confusion, here's my 9.3 vs 9.4 on two M550 (one for 9.3 one for 9.4), see below for results. I'm running xfs on them

[PERFORM] postgres 9.3 vs. 9.4

Hi Folk, I am trying to investigate some performance issues which we have with postgres (a different topic by itself) and tried postgres.9.4beta2, with a hope that it perform better. Turned out that 9.4 is 2x slower than 9.3.5 on the same hardware. Some technical details: Host: rhel 6.5

Re: [PERFORM] postgres 9.3 vs. 9.4

- Original Message - From: Mark Kirkwood mark.kirkw...@catalyst.net.nz To: Tigran Mkrtchyan tigran.mkrtch...@desy.de, pgsql-performance@postgresql.org Sent: Thursday, September 18, 2014 12:17:45 PM Subject: Re: [PERFORM] postgres 9.3 vs. 9.4 On 18/09/14 21:58, Mkrtchyan, Tigran

Re: [PERFORM] postgres 9.3 vs. 9.4

- Original Message - From: Jeff Janes jeff.ja...@gmail.com To: Tigran Mkrtchyan tigran.mkrtch...@desy.de Cc: pgsql-performance@postgresql.org Sent: Thursday, September 18, 2014 4:56:22 PM Subject: Re: [PERFORM] postgres 9.3 vs. 9.4 On Thu, Sep 18, 2014 at 2:58 AM, Mkrtchyan

Re: [PERFORM] postgres 9.3 vs. 9.4

- Original Message - From: Josh Berkus j...@agliodbs.com To: pgsql-performance@postgresql.org Sent: Thursday, September 18, 2014 7:54:24 PM Subject: Re: [PERFORM] postgres 9.3 vs. 9.4 On 09/18/2014 08:09 AM, Mkrtchyan, Tigran wrote: 9.4beta2: ... 0.957854

Re: [PERFORM] postgres 9.3 vs. 9.4

On Sep 18, 2014 9:32 PM, Andrew Dunstan and...@dunslane.net wrote: On 09/18/2014 03:09 PM, Mkrtchyan, Tigran wrote: - Original Message - From: Josh Berkus j...@agliodbs.com To: pgsql-performance@postgresql.org Sent: Thursday, September 18, 2014 7:54:24 PM Subject: Re

Re: [PERFORM] postgres 9.3 vs. 9.4

, 2014 at 4:58 AM, Mkrtchyan, Tigran tigran.mkrtch...@desy.de wrote: 9.3.5: 0.035940END; 9.4beta2: 0.957854END; time being spent on 'END' is definitely suggesting i/o related issues. This is making me very skeptical that postgres is the source

Re: [PERFORM] postgres 9.3 vs. 9.4

: [PERFORM] postgres 9.3 vs. 9.4 On 19/09/14 08:32, Merlin Moncure wrote: On Thu, Sep 18, 2014 at 4:58 AM, Mkrtchyan, Tigran tigran.mkrtch...@desy.de wrote: 9.3.5: 0.035940END; 9.4beta2: 0.957854END; time being spent on 'END' is definitely

Re: [PERFORM] postgres 9.3 vs. 9.4

] postgres 9.3 vs. 9.4 On 19/09/14 10:16, Mark Kirkwood wrote: On 19/09/14 09:10, Mkrtchyan, Tigran wrote: - Original Message - From: Mark Kirkwood mark.kirkw...@catalyst.net.nz To: Merlin Moncure mmonc...@gmail.com, Tigran Mkrtchyan tigran.mkrtch...@desy.de Cc: postgres