Re: [PERFORM] PostgreSQL 9.2.4 very slow on laptop with windows 8

As I see only Windows7 supported ( with EnterpriseDB version of PostgreSQL 9.2 Windows installer ) http://www.enterprisedb.com/products-services-training/products-overview/postgresql-overview/supported-platforms-and-release-lif Have you been tested with PostgreSQL 9.3 rc1 ? same speed ?

Re: [PERFORM] postgres 9.3 vs. 9.4

Hi Tigran, my debugging tips: Some technical details: Host: rhel 6.5 2.6.32-431.23.3.el6.x86_64 256 GB RAM, 40 cores, Intel(R) Xeon(R) CPU E5-2660 v2 @ 2.20GHz 2x160GB PCIe SSD DELL_P320h-MTFDGAL175SAH As I know PCIe SSD DELL_P320h = Micron P320h (

Re: [PERFORM] can't explain commit performance win7 vs linux : 8000/s vs 419/s

my guess: - maybe the NTFS compression is enabled? [ "Compress this drive to save disk space” ? ] [ your test data is ideal for compression: VALUES ('AA.. 250 times') ] - or Windows Samsung Magician extreme settings? or RAPID mode cache enabled? "RAPID mode is a RAM caching feature.

Re: [PERFORM] Poor disk (virtio) Performance Inside KVM virt-machine vs host machine

>I've noticed that there is a huge (more than ~3x slower) performance difference between KVM guest and host machine. I don't know that this is relevant or not , but there is an IBM research paper (Published in 2014) "IBM Research Report - An Updated Performance Comparison of Virtual Machines and

Re: [PERFORM] pgtune or similar to assist in initial settings

> So looking for a good start as I start bringing up systems in Amazon, AWS for performance. Maybe useful information: - "Amazon Web Services – RDBMS in the Cloud: PostgreSQL on AWS" (2013) https://aws.amazon.com/whitepapers/postgresql-in-the-cloud/ Download Whitepaper

Re: [PERFORM] How to tune Postgres to take advantage of 256GB RAM hardware

> I am trying to configure Postgres (version 9.5) This is the latest PG 9.5 ? ( = 9.5.5 ? [ Release Date : 2016-10-27 ] ) 2016-11-24 9:17 GMT+01:00 Carmen Mardiros : > Hi Andreas, > > Thanks for the reply.