Re: performance of pg_upgrade "Copying user relation files"

On 10/2/19 5:47 PM, Adrian Klaver wrote: On 10/2/19 4:58 PM, Glenn Pierce wrote: Please reply to list also. Ccing list. On Thu, 3 Oct 2019, 00:11 Adrian Klaver, > wrote:     On 10/2/19 3:30 PM, Glenn Pierce wrote: > I have been trying to upgrade postgre

Re: performance of pg_upgrade "Copying user relation files"

On 10/2/19 4:58 PM, Glenn Pierce wrote: Please reply to list also. Ccing list. On Thu, 3 Oct 2019, 00:11 Adrian Klaver, > wrote: On 10/2/19 3:30 PM, Glenn Pierce wrote: > I have been trying to upgrade postgres 9.5 to 9.6 with pg_upgrade > >

Re: performance of pg_upgrade "Copying user relation files"

On 10/2/19 3:30 PM, Glenn Pierce wrote: I have been trying to upgrade postgres 9.5 to 9.6 with pg_upgrade Everything seems to start fine but when pg_upgrade gets to "Copying user relation files" It takes ages to complete copying. Adding to previous list: 4) Which pg_upgrade version did you us

Re: performance of pg_upgrade "Copying user relation files"

On 10/2/19 3:30 PM, Glenn Pierce wrote: I have been trying to upgrade postgres 9.5 to 9.6 with pg_upgrade Everything seems to start fine but when pg_upgrade gets to "Copying user relation files" It takes ages to complete copying. This is going to need more information: 1) What is the pg_upgra

performance of pg_upgrade "Copying user relation files"

I have been trying to upgrade postgres 9.5 to 9.6 with pg_upgrade Everything seems to start fine but when pg_upgrade gets to "Copying user relation files" It takes ages to complete copying. ie Each file like /var/lib/pgsql/9.5/data/base/24602/25140 is 1G and taking ~5-10 minutes to copyand that