From: Craig Ringer <ringerc@ringerc.id.au>
To: Samuel Gendler <sgendler@ideasculptor.com>
Cc: Reza Taheri <rtaheri@vmware.com>
Cc: Robert Klemme <shortcutter@googlemail.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: The need for clustered indexes to boost TPC-V performance
Date: Fri, 06 Jul 2012 08:57:40 +0800
Message-ID: <4FF63804.2060107@ringerc.id.au> (raw)
In-Reply-To: <CAEV0TzAZT0C62qdJO9wo=bKWVB6X2gTxVOVihRhgkX9B7kX6sw@mail.gmail.com>
References: <66CE997FB523C04E9749452273184C6C137CB88A86@exch-mbx-113.vmware.com>
<CAM9pMnPxJ8i53aP=n7azT8sF5xiuWJzHPP-e-6qHdWozJCUbpw@mail.gmail.com>
<66CE997FB523C04E9749452273184C6C137CB88CF9@exch-mbx-113.vmware.com>
<CAEV0TzAFXapqsK4e98s4qxnNYFCm0ocYrrknb1h-Amta-OBh+w@mail.gmail.com>
<66CE997FB523C04E9749452273184C6C137CB88D2C@exch-mbx-113.vmware.com>
<CAEV0TzAZT0C62qdJO9wo=bKWVB6X2gTxVOVihRhgkX9B7kX6sw@mail.gmail.com>
On 07/06/2012 04:52 AM, Samuel Gendler wrote:
>
>
> On Thu, Jul 5, 2012 at 1:37 PM, Reza Taheri <rtaheri@vmware.com
> <mailto:rtaheri@vmware.com>> wrote:
>
>
> I provided more config details in an earlier email.
>
>
>
> I hate to disagree, but unless I didn't get a message sent to the list
It looks like that might be the case. I got a message with Message-ID
66CE997FB523C04E9749452273184C6C137CB88CDD@exch-mbx-113.vmware.com sent
at Thu, 5 Jul 2012 11:33:46 -0700 that contained the basic info,
postgresql.conf, etc. Belated, but it was sent. I can't find this
message in the archives and the copy I got came direct to me via cc, so
I suspect our friendly mailing list system has silently held it for
moderation due to size/attachment.
I'll reproduce the content below, followed by an inline copy of the
postgresql.conf with only changed lines:
On 07/06/2012 02:33 AM, Reza Taheri wrote:
>
> OK, some config details.
>
> We are using:
>
> ·Two blades of an HP BladeSystem c-Class c7000 with 2-socket Intel
> E5520 (Nehalem-EP) processors and 48GB of memory per blade
>
> o8 cores, 16 threads per blade
>
> o48GB of RAM per blade
>
> ·Storage was an EMC VNX5700 with 14 SSDs fronting 32 15K RPM drives
>
> ·The Tier B database VM was alone on a blade with 16 vCPUs, 40GB of
> memory, 4 virtual drives with various RAID levels
>
> ·The driver and Tier A VMs were on the second blade
>
> oSo we set PGHOST on the client system to point to the server
>
> ·RHEL 6.1
>
> ·PostgreSQL 8.4
>
> ·unixODBC 2.3.2
>
> We stuck with PGSQL 8.4 since it is the stock version shipped with
> RHEL 6. I am building a new, larger testbed, and will switch to PGSQL
> 9 with that.
>
>
postgresql.conf:
[craig@ayaki ~]$ egrep -v '(^\s*#)|(^\s*$)' /tmp/postgresql2.conf | cut
-d '#' -f 1
listen_addresses = '*'
max_connections = 320
shared_buffers = 28GB
temp_buffers = 200MB
work_mem = 10MB
maintenance_work_mem = 10MB
bgwriter_delay = 10ms
bgwriter_lru_maxpages = 20
wal_buffers = 16MB
checkpoint_segments = 128
checkpoint_timeout = 30min
checkpoint_completion_target = 0.9
default_statistics_target = 10000
logging_collector = on
log_directory = 'pg_log'
log_filename = 'postgresql-%a.log'
log_truncate_on_rotation = on
log_rotation_age = 1d
log_rotation_size = 0
datestyle = 'iso, mdy'
lc_messages = 'en_US.UTF-8'
lc_monetary = 'en_US.UTF-8'
lc_numeric = 'en_US.UTF-8'
lc_time = 'en_US.UTF-8'
default_text_search_config = 'pg_catalog.english'
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ringerc@ringerc.id.au, sgendler@ideasculptor.com, rtaheri@vmware.com, shortcutter@googlemail.com
Subject: Re: The need for clustered indexes to boost TPC-V performance
In-Reply-To: <4FF63804.2060107@ringerc.id.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox