Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Ye3b7-00045S-VJ for pgsql-performance@arkaria.postgresql.org; Fri, 03 Apr 2015 15:33:30 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Ye3b7-0007sl-1C for pgsql-performance@arkaria.postgresql.org; Fri, 03 Apr 2015 15:33:29 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Ye3b6-0007se-5i for pgsql-performance@postgresql.org; Fri, 03 Apr 2015 15:33:28 +0000 Received: from mail-wg0-x229.google.com ([2a00:1450:400c:c00::229]) by magus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1Ye3b1-0005h3-HT for pgsql-performance@postgresql.org; Fri, 03 Apr 2015 15:33:26 +0000 Received: by wgbdm7 with SMTP id dm7so113851138wgb.1 for ; Fri, 03 Apr 2015 08:33:22 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=content-type:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=dwKo2pexeToCKmbCzZqf68OPd8bPcx/BOwt4Q96c3WI=; b=eflglDrJlJE9pB1sYnwJovg9S+4OUFr2xiYxpcp7oqwrLvNPyB8UEZ4EkX1eOSG0Ku qVWAw8uI8FdtEeD0leRThwRZjbgCMNjvnymuVUUw2g8DqLnbhf5kZteUHKGQ/yEk/N46 ze7X7CJCKo+GNq6gL+tKZz+DolMdI0pFqUxr3BtE9QI1mmUN3PwR9Q99RhNqK1W7eQv0 OdHohVhOTBuk62ObTWG4fQKneBXo2SVN6jprQlysjrL6InwpzGoMgA6zpjfaUuVDQbEe wxlYZIncDFZpa8eB7p30BfareZFyN8JtovAoPqhDiQ1W2IRIDDguqZK8JbGUGsD8YgfG 2HQg== X-Received: by 10.180.126.41 with SMTP id mv9mr35000350wib.72.1428075202292; Fri, 03 Apr 2015 08:33:22 -0700 (PDT) Received: from [192.168.2.2] (2-230-140-245.ip202.fastwebnet.it. [2.230.140.245]) by mx.google.com with ESMTPSA id es2sm3166625wib.8.2015.04.03.08.33.21 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Fri, 03 Apr 2015 08:33:21 -0700 (PDT) Content-Type: text/plain; charset=windows-1252 Mime-Version: 1.0 (Mac OS X Mail 7.3 \(1878.6\)) Subject: Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL From: Pietro Pugni In-Reply-To: Date: Fri, 3 Apr 2015 17:33:20 +0200 Cc: PostgreSQL Performance Content-Transfer-Encoding: quoted-printable Message-Id: References: <87131335.225702.1427941178942.JavaMail.root@fmed.uba.ar> <2EBBCD54-D3C8-436F-AF73-84EEF258AB70@gmail.com> <76EF504C-06AF-471F-8BCD-AFD2B6F85178@gmail.com> <4D51FE53-2614-4D5E-8657-79485BF7D6E0@gmail.com> To: Josh Krupka X-Mailer: Apple Mail (2.1878.6) X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org Hi Josh, at the moment the server is unreachable so I can=92t calculate sizes. I run= all of my test both with all data loaded into Postgres and with no data lo= aded (except from the single 20mln rows table with relative indexes). To give you an idea, with all data loaded into Postgres with indexes the sp= ace occupied is approximately 1.2-1.5TB and free space on is about 800GB. Many thanks. Best regads, Pietro Il giorno 03/apr/2015, alle ore 17:21, Josh Krupka ha s= critto: > Sorry, how much disk space is actually used by the tables, indexes, etc i= nvolved in your queries? Or it that's a bit much to get, how much disk spac= e is occupied by your database in total? --=20 Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance