MIME-Version: 1.0
In-Reply-To: 
 <CABUL136zJCFv37rLA+yhpWgvAb6iWnp7RGp7VvFBwqoPE9E30Q@mail.gmail.com>
References: 
 <CABUL134EOvvkqfoMYWQr05D+VjEVu0cuSHT8rtf-7b6QvGedXQ@mail.gmail.com>
 <CAOR=d=0OmV2RwMEqZ2gC2e=tU-RWe0EuSs5QSspGxFP28+xzLw@mail.gmail.com>
 <CABUL136zJCFv37rLA+yhpWgvAb6iWnp7RGp7VvFBwqoPE9E30Q@mail.gmail.com>
From: Scott Marlowe <scott.marlowe@gmail.com>
Date: Tue, 1 Aug 2017 09:13:47 -0700
Message-ID: 
 <CAOR=d=3T7uRvT2or0i3_00uJ0d85tC8Zt_0m0WJV_otjjMfCpg@mail.gmail.com>
Subject: Re: 2 server with same configuration but huge difference in
 performance
To: Sumeet Shukla <sumeet.k.shukla@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>,
	"pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

On Tue, Aug 1, 2017 at 8:45 AM, Sumeet Shukla <sumeet.k.shukla@gmail.com> wrote:
> It seems that it is happening because of the way the database is created. On
> an old database it runs perfectly fine or if I use the old DB as template to
> create the new one, it  runs fine. But if I create a new DB with same
> settings and permissions it hangs. I'm now trying to find the difference
> between these 2 databases.

Likely a difference in encoding or collation. What does \l show you
(that's a lower case L btw)

smarlowe=> \l
                                  List of databases
   Name    |  Owner   | Encoding |   Collate   |    Ctype    |
Access privileges
-----------+----------+----------+-------------+-------------+-----------------------
 postgres  | smarlowe | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 smarlowe  | smarlowe | UTF8     | en_US.UTF-8 | en_US.UTF-8 |

UTF8 and en_US are much more expensive than SQL_ASCII and C would be
for text and such. Basically indexes either don't work or work as well
under en_US if you're comparing or sorting text.


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