public inbox for [email protected]
help / color / mirror / Atom feedFrom: Naveen Kumar <[email protected]>
To: Sumeet Shukla <[email protected]>
Cc: pgsql-admin <[email protected]>
Cc: [email protected] <[email protected]>
Cc: Scott Marlowe <[email protected]>
Subject: Re: [PERFORM] 2 server with same configuration but huge difference in performance
Date: Wed, 2 Aug 2017 03:44:46 +0530
Message-ID: <CADk76jqabbbTDTy6G8nShYwQx=LxqzV8FnmiebiS_4R6_agimQ@mail.gmail.com> (raw)
In-Reply-To: <CAOR=d=3T7uRvT2or0i3_00uJ0d85tC8Zt_0m0WJV_otjjMfCpg@mail.gmail.com>
References: <CABUL134EOvvkqfoMYWQr05D+VjEVu0cuSHT8rtf-7b6QvGedXQ@mail.gmail.com>
<CAOR=d=0OmV2RwMEqZ2gC2e=tU-RWe0EuSs5QSspGxFP28+xzLw@mail.gmail.com>
<CABUL136zJCFv37rLA+yhpWgvAb6iWnp7RGp7VvFBwqoPE9E30Q@mail.gmail.com>
<CAOR=d=3T7uRvT2or0i3_00uJ0d85tC8Zt_0m0WJV_otjjMfCpg@mail.gmail.com>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-admin>
Hello Sumeet,
Compare schema on both database to make sure there is no mismatches. And
verify LOCKs. if all looks good,
do analyze on newly created database before start execution. This will help
you. New database doesn't have any stats for generate execution plan.
Thanks & Regards,
Naveen Kumar .M,
Sr. PostgreSQL Database Administrator,
Mobile: 7755929449.
*My attitude will always be based on how you treat me. *
On Tue, Aug 1, 2017 at 9:43 PM, Scott Marlowe <[email protected]>
wrote:
> On Tue, Aug 1, 2017 at 8:45 AM, Sumeet Shukla <[email protected]>
> 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-admin mailing list ([email protected])
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
reply
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: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: [PERFORM] 2 server with same configuration but huge difference in performance
In-Reply-To: <CADk76jqabbbTDTy6G8nShYwQx=LxqzV8FnmiebiS_4R6_agimQ@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox