Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-performance-owner+M55230=pgsql-performance-ar@postgresql.org>)
	id 1dUajJ-0005o3-7v
	for pgsql-performance@arkaria.postgresql.org; Mon, 10 Jul 2017 15:36:09 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgsql-performance-owner+M55230=pgsql-performance-ar@postgresql.org>)
	id 1dUajI-0008TA-Qz
	for pgsql-performance@arkaria.postgresql.org; Mon, 10 Jul 2017 15:36:08 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <andreas@a-kretschmer.de>)
	id 1dUajI-0008St-5j
	for pgsql-performance@postgresql.org; Mon, 10 Jul 2017 15:36:08 +0000
Received: from mailout01.ims-firmen.de ([213.174.32.96])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <andreas@a-kretschmer.de>)
	id 1dUajB-0000NN-1r
	for pgsql-performance@postgresql.org; Mon, 10 Jul 2017 15:36:06 +0000
Received: from mailin01.ims-firmen.de ([192.168.1.141])
	by mailout01.ims-firmen.de with esmtp
	(envelope-from <andreas@a-kretschmer.de>)
	id 1dUaj7-0001d8-gU
	for pgsql-performance@postgresql.org; Mon, 10 Jul 2017 17:35:57 +0200
Received: from [79.204.138.247] (helo=[192.168.222.103])
	by mailin01.ims-firmen.de with esmtpa
	(envelope-from <andreas@a-kretschmer.de>)
	id 1dUaj7-0001Nt-0A
	for pgsql-performance@postgresql.org; Mon, 10 Jul 2017 17:35:57 +0200
Subject: Re: Very poor read performance, query independent
To: pgsql-performance@postgresql.org
References: 
 <CADFyZw7aGoD0AaStxdyHByR5Qta=M5wx0v=iptKLhPUp+EOKvA@mail.gmail.com>
From: Andreas Kretschmer <andreas@a-kretschmer.de>
Message-ID: <dc5d2b63-0a1b-ff76-c88a-87c2c41bd5b8@a-kretschmer.de>
Date: Mon, 10 Jul 2017 17:35:56 +0200
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101
 Thunderbird/45.8.0
MIME-Version: 1.0
In-Reply-To: 
 <CADFyZw7aGoD0AaStxdyHByR5Qta=M5wx0v=iptKLhPUp+EOKvA@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org



Am 10.07.2017 um 16:03 schrieb Charles Nadeau:
> random_page_cost | 22 


why such a high value for random_page_cost?

Regards, Andreas

-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com



-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance