From: Tom Lane <tgl@sss.pgh.pa.us>
To: p kirti <kirtip92@gmail.com>
cc: pgsql-performance@postgresql.org
Subject: Re: DB slowness after upgrade from Postgres 9.1 to 9.4
In-reply-to: 
 <CAFgnfScjp=-joWVAyXE+v+zDRZ98SvcovUinmKLx2h2kGq6ePg@mail.gmail.com>
References: 
 <CAFgnfSdS1twkog+pF_2v3o3e9RdSn2EuLzoF_z+95J3yvY=HnA@mail.gmail.com>
 <CAFgnfSf8jb__cmP_2ibet_-EuS=5YogyEhbme7qvtzoLn+XURA@mail.gmail.com>
 <CAFgnfSfPEUMRGa-sps_42EKRT+2c4EDsj87k16N7envzc8wfZw@mail.gmail.com>
 <CAFgnfScuLribfQUDS2L7ygr_m9prtorjTN5DzLZoe-cdJro9WQ@mail.gmail.com>
 <CAFgnfSckWF=n89rfj5NxxyTrt6OFqNHPidjfwvUYMEZATv-89A@mail.gmail.com>
 <CAFgnfSe6sh+cfmX=6UfnmkGqJhirHTFOgFvZPKYO2=keeUz8RQ@mail.gmail.com>
 <CAFgnfSeeumftnG=jAhS1hCah3KUvWQNF4_9RySgZ_WfOvKsOYQ@mail.gmail.com>
 <CAFgnfSe-ki5nSzt2MeeFPefi_kM3ffRJbh_xOQiJvdn-mWFYEg@mail.gmail.com>
 <CAFgnfSf-bxBBBa0wW2nMsufQZ+g1BBy7rnO81EWvcF8BJev2tg@mail.gmail.com>
 <CAFgnfSc7kYKvhu4oKxD-VQF4WjDE2hc+f3owuHnMKBYUxdAMCw@mail.gmail.com>
 <CAFgnfSdzy2Q8AM9iE-qRwOO3U-kqGjDHu3aQPjBZni0906Hmsw@mail.gmail.com>
 <CAFgnfSci8qbUmP62zXh-JnmDqd1LkBHpjB-UK+r-635v5FDqBQ@mail.gmail.com>
 <CAFgnfSf-_6xE-ObbdUF8Ysk+LigpKkrn5Gom1knoFdF8X2iKCw@mail.gmail.com>
 <CAFgnfSfsk6ZXA3CnQBL5hzpk_b77CxsvvEO2PasExGybnCD9XQ@mail.gmail.com>
 <CAFgnfSeSL!
 AL5M7q5LzZ3r93R8pQ0oBy0yi8_7a8JjQabfGGn9w@mail.gmail.com>
 <CAFgnfScCosFudCvPTqxVGLZKudmcZZ=p6M+0-MhktAYmtujBcQ@mail.gmail.com>
 <CAFgnfSea1wtkDzM6-a=HNkk50DPaWGPDoEND++PLeXWq=2aO-w@mail.gmail.com>
 <CAFgnfSfoBzVL2N=S=X1qBL9777qdaW+Z_2qUd4VgiyitTVzZog@mail.gmail.com>
 <CAFgnfSem6f4exu5zOd9wge6mfD2a+xkpex1OPVp7_1goWPFn_Q@mail.gmail.com>
 <CAFgnfSccFUfXH02j-hiEACiY8w0Qzw7guD6FVAot+VaJ5MsWhQ@mail.gmail.com>
 <CAFgnfSf271DtZ8MRbrRNPMKYZjahEzF=q7vMt0+byxfL+NOreA@mail.gmail.com>
 <CAFgnfScjp=-joWVAyXE+v+zDRZ98SvcovUinmKLx2h2kGq6ePg@mail.gmail.com>
Comments: In-reply-to p kirti <kirtip92@gmail.com>
	message dated "Fri, 10 Nov 2017 16:28:41 +0530"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <21899.1510515458.1@sss.pgh.pa.us>
Date: Sun, 12 Nov 2017 14:37:38 -0500
Message-ID: <21900.1510515458@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

p kirti <kirtip92@gmail.com> writes:
> We have recently upgraded our project with a huge DB from Postgres v9.1 to
> v9.4. The whole system performance has degraded alarmingly after the
> upgrade. Simple operations that were taking only a few seconds in Postgres
> 9.1 are now taking minutes of time.

Are you certain nothing else changed?  Same hardware, same OS, same
database configuration settings?

Once you've eliminated issues like that, you'd need to drill down deeper.
There's useful advice to help crystallize the situation at
https://wiki.postgresql.org/wiki/Slow_Query_Questions

			regards, tom lane


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