pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Debraj Manna <subharaj.manna@gmail.com>
Cc: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
Cc: Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Faster way of upgrading postgresql to 10 from 9.5
Date: Sat, 25 Nov 2017 12:29:17 -0500
Message-ID: <3504.1511630957@sss.pgh.pa.us> (raw)
In-Reply-To: <CAF6DVKPFky-+MpBQH8h-FM7--fyhk6unL56FbuKezobaoAijLw@mail.gmail.com>
References: <CAF6DVKOZOqFPLFcnmxF6PU7j7NMkQN90jkb8af-gTRAyfZKZ_w@mail.gmail.com>
	<jdhahc12n02hggumet17qaok.1511582685139@email.android.com>
	<CAF6DVKNrE86fKEJhw4YCs5erekKCTJXnq5sWHc_C5wR5XJo6Rg@mail.gmail.com>
	<hbcp5fi9i6fpjd66b6r2a8p7.1511586597413@email.android.com>
	<CAF6DVKPf7++_RGYY5xDNyhXhix6RYeNOT2VT_C0AC+Cs=PbWDA@mail.gmail.com>
	<4d397bf0-14c3-2bf8-bee6-c023a654b7ef@catalyst.net.nz>
	<CAF6DVKPHbwf+B-Q_e+UoZgbf2ht3vMV1qa2GgnuED_pRR+5LBw@mail.gmail.com>
	<a1a12fbe-f5aa-542f-77f2-5220b24d917c@catalyst.net.nz>
	<CAF6DVKOW_zbyU2fH5RRqm-CddxmkfygYdaMs1EiUpXi10p01Zg@mail.gmail.com>
	<776.1511623176@sss.pgh.pa.us>
	<CAF6DVKPFky-+MpBQH8h-FM7--fyhk6unL56FbuKezobaoAijLw@mail.gmail.com>

Debraj Manna <subharaj.manna@gmail.com> writes:
> What profiling will help in this case?

If you're on a reasonably modern Linux platform, I'd try "perf",
which is capable of gathering a system-wide profile.  Note you
will need debug symbols installed for Postgres to get good
results from any profiling tool.

			regards, tom lane




view thread (17+ messages)

Message-ID: <3504.1511630957@sss.pgh.pa.us>
Permalink:  ../3504.1511630957@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/3504.1511630957@sss.pgh.pa.us

 · 

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: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, subharaj.manna@gmail.com, mark.kirkwood@catalyst.net.nz, aaguayo@opensysperu.com
  Subject: Re: Faster way of upgrading postgresql to 10 from 9.5
  In-Reply-To: <3504.1511630957@sss.pgh.pa.us>

* 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