Postgres Pro
Downloads
Home   >   mailing lists

Re: Copy command Faster than original select - Mailing list pgsql-performance

From Matheus de Oliveira
Subject Re: Copy command Faster than original select
Date
Msg-id CAJghg4+2m=Pv5_62Wqtk+Rpgbs0FaAL69edBfk08qZA9O_H_UA@mail.gmail.com
Whole thread Raw
In response to Re: Copy command Faster than original select  (Belal Al-Hamed <belalhamed@gmail.com>)
Responses Re: Copy command Faster than original select
List pgsql-performance
Tree view

On Fri, Feb 6, 2015 at 6:44 AM, Belal Al-Hamed <belalhamed@gmail.com> wrote:

but isn't copy use the same plan ???

any way this is the query play

"Sort  (cost=15402.76..15511.77 rows=43602 width=184)"

Can you try again but with EXPLAIN *ANALYZE* (not only EXPLAIN)?

Best regards,
--
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres

pgsql-performance by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Copy command Faster than original select
Next
From: Belal Al-Hamed
Date:
Subject: Re: Copy command Faster than original select