Re: Postgres performance comparing GCP and AWS

2021-02-26 Thread Igor Gois
24 seconds (aws) and 300+ seconds in gcp Thank you Em qui., 25 de fev. de 2021 às 17:53, Philip Semanchuk < phi...@americanefficient.com> escreveu: > > > > On Feb 25, 2021, at 3:46 PM, Igor Gois > wrote: > > > > Hi, Philip > > > > We ran: EXPLAIN (FO

Re: Postgres performance comparing GCP and AWS

2021-02-26 Thread Igor Gois
pesz.com/s/5HRO Thanks in advance Em qui., 25 de fev. de 2021 às 15:13, Philip Semanchuk < phi...@americanefficient.com> escreveu: > > > > On Feb 24, 2021, at 10:11 AM, Igor Gois > wrote: > > > > Hi, Julien > > > > Your hypothesis about network transfer

Re: Postgres performance comparing GCP and AWS

2021-02-24 Thread Igor Gois
t's likely due to quite slow > network transfer. Otherwise we would need an explain plan from the > slow execution, for which auto_explain can help you. See > https://www.postgresql.org/docs/11/auto-explain.html for more details. > -- *Att,* *Igor Gois | Sócio Consultor* (4