Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YfX8M-0006qN-Ro for pgsql-performance@arkaria.postgresql.org; Tue, 07 Apr 2015 17:17:55 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YfX8L-00033J-Pi for pgsql-performance@arkaria.postgresql.org; Tue, 07 Apr 2015 17:17:53 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YfX8K-00032y-Cx for pgsql-performance@postgresql.org; Tue, 07 Apr 2015 17:17:52 +0000 Received: from mail-wi0-x235.google.com ([2a00:1450:400c:c05::235]) by makus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YfX8C-00084L-C8 for pgsql-performance@postgresql.org; Tue, 07 Apr 2015 17:17:50 +0000 Received: by wiax7 with SMTP id x7so15558134wia.0 for ; Tue, 07 Apr 2015 10:17:42 -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 :message-id:references:to; bh=hN9wcyJ61E1fBbc9qLj3mKjVahiLwmJI69IMMCUdQU0=; b=pV79PiI95fQz8CHzDFxSgKrEPmm6ln1EueMXDZzQvXgci69gAOnpptaip5pWgnvkry nPHTV6tnBliQp9lhB7ue3w+70k4zS7rEl10wGikuCT1SNdFq65OHrO8mbUZlLClQy8/z wYyArNUgicfW3ten2pE+0Yf1S0uyzJ8Shdfj1Z8JD9cjrSSS2DAamOd7nXK3oUZ99Ttm D0swwMLSKzaGGlOV6a14SJG1JU0a+2ODs6f/WOrC3GG+QXpBLVGKCLrHc0brVEEjRAQ+ 4Dxq22KutCP9x7ayf+aVvANbkWilRj+OnlRBEOMfhlt7ko92xkzO+dzX89kUloVg0u7V Sjkg== X-Received: by 10.180.101.225 with SMTP id fj1mr6577516wib.56.1428427062686; Tue, 07 Apr 2015 10:17:42 -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 u6sm11821362wjy.13.2015.04.07.10.17.41 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Tue, 07 Apr 2015 10:17:41 -0700 (PDT) Content-Type: multipart/alternative; boundary="Apple-Mail=_02017EA0-87F3-4D24-B92B-1198C5C00B59" 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: <051212BE-A86B-4874-8BAC-18F609DE8229@gmail.com> Date: Tue, 7 Apr 2015 19:17:40 +0200 Cc: PostgreSQL Performance Message-Id: <697FB244-B9B8-4918-AEAC-20FD5539C0E8@gmail.com> References: <732B95A3-FEC8-4623-9AC5-98FD30F00863@gmail.com> <2F18FF84-5408-4AE8-9F2B-9110F76DED86@gmail.com> <5CC78F3A-8FD3-447F-8AB3-98BE80658E79@gmail.com> <051212BE-A86B-4874-8BAC-18F609DE8229@gmail.com> To: Jeff Janes 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 --Apple-Mail=_02017EA0-87F3-4D24-B92B-1198C5C00B59 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=windows-1252 I meant =93collation=94, not =93collection=94. Pietro Il giorno 07/apr/2015, alle ore 18:49, Pietro Pugni = ha scritto: > =09 >> On Tue, Apr 7, 2015 at 6:27 AM, Pietro Pugni = wrote: >> Hi Jeff, >> sorry for the latency but server was down due to a error I made in = the sysctl.conf file. >>> Yes, but are the defaults for those two systems? on psql, use \l to = see. >>>=20 >>=20 >> \l returns the following: >>=20 >> T420 (Postgres 9.4.1) >> List of databases >> Name | Owner | Encoding | Collate | Ctype | = Access privileges =20 >> = -----------+----------+----------+-------------+-------------+------------= ----------- >> grep | grep | UTF8 | en_US.UTF-8 | en_US.UTF-8 |=20 >> postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |=20 >> template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | = =3Dc/postgres + >> | | | | | = postgres=3DCTc/postgres >> template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | = =3Dc/postgres + >> | | | | | = postgres=3DCTc/postgres >> (4 rows) >>=20 >>=20 >>=20 >> MacMini (Postgres 9.0.13) >> List of databases >> Name | Owner | Encoding | Collation | Ctype | = Access privileges =20 >> = -------------------+------------+----------+-----------+-------+----------= --------------- >> caldav | caldav | UTF8 | C | C |=20 >> collab | collab | UTF8 | C | C |=20 >> device_management | _devicemgr | UTF8 | C | C |=20 >> pen | pen | UTF8 | C | C |=20 >> postgres | _postgres | UTF8 | C | C |=20 >> roundcubemail | roundcube | UTF8 | C | C |=20 >> template0 | _postgres | UTF8 | C | C | = =3Dc/_postgres + >> | | | | | = _postgres=3DCTc/_postgres >> template1 | _postgres | UTF8 | C | C | = =3Dc/_postgres + >> | | | | | = _postgres=3DCTc/_postgres >> (8 rows) >>=20 >>=20 >> The difference between the "C" and the "en_US" collation is entirely = sufficient to explain the difference in performance. "C" is the fastest = possible collation as it never needs to look ahead or consult tables, it = just compares raw bytes. >>=20 >> Cheers, >>=20 >> Jeff >=20 > Hi Jeff, > is there a way to set a default collection during compiling or in the = configuration file? I have never specified one, so I suppose that = somewhere on MacMini =93C=94 collation type is set as the default one. >=20 > Thank you a lot. > Best regards, > Pietro --Apple-Mail=_02017EA0-87F3-4D24-B92B-1198C5C00B59 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=windows-1252
I = meant =93collation=94, not = =93collection=94.

 Pietro

Il giorno 07/apr/2015, alle ore 18:49, Pietro Pugni <pietro.pugni@gmail.com> ha = scritto:

=
On Tue, Apr = 7, 2015 at 6:27 AM, Pietro Pugni <pietro.pugni@gmail.com> wrote:
Hi= Jeff,
sorry for the latency but server was down due to a = error I made in the sysctl.conf file.

Yes, but are the defaults for those = two systems?  on psql, use \l to = see.

\l returns the = following:

T420 (Postgres = 9.4.1)
      =                     =         List of databases
   Name    |  Owner   | = Encoding |   Collate   |    Ctype    | =   Access privileges   
-----------+----------+----------+-------------+---------= ----+-----------------------
 grep      | grep     | = UTF8     | en_US.UTF-8 | en_US.UTF-8 = | 
 postgres  | = postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 = | 
 template0 | = postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =3Dc/postgres =          +
           |   =        |          |   =           |           =   | postgres=3DCTc/postgres
 template1 | postgres | UTF8     | = en_US.UTF-8 | en_US.UTF-8 | =3Dc/postgres         =  +
      =      |          |     =      |             |   =           | = postgres=3DCTc/postgres
(4 = rows)



=
MacMini (Postgres 9.0.13)
                =                     = List of databases
    =    Name        |   Owner   =  | Encoding | Collation | Ctype |    Access privileges =    
-------------------+------------+----------+-----------+-= ------+-------------------------
 caldav            | = caldav     | UTF8     | C       =   | C     | 
 collab            | = collab     | UTF8     | C       =   | C     | 
 device_management | _devicemgr | UTF8   =   | C         | C     = | 
 pen     =           | pen        | = UTF8     | C         | C     = | 
 postgres   =        | _postgres  | UTF8     | C =         | C     = | 
 roundcubemail =     | roundcube  | UTF8     | C     =     | C     | 
 template0         | _postgres =  | UTF8     | C         | C   =   | =3Dc/_postgres           = +
        =            |         =    |          |       =     |       | = _postgres=3DCTc/_postgres
 template1         | _postgres =  | UTF8     | C         | C   =   | =3Dc/_postgres           = +
        =            |         =    |          |       =     |       | = _postgres=3DCTc/_postgres
(8= rows)


The = difference between the "C" and the "en_US" collation is entirely = sufficient to explain the difference in performance.  "C" is the = fastest possible collation as it never needs to look ahead or consult = tables, it just compares raw bytes.

Cheers,

Jeff

Hi Jeff,
is there a way to set a = default collection during compiling or in the configuration file? I have = never specified one, so I suppose that somewhere on MacMini =93C=94 = collation type is set as the default one.

Thank = you a lot.
Best = regards,
 Pietro

<= /html>= --Apple-Mail=_02017EA0-87F3-4D24-B92B-1198C5C00B59--