Re: Diagnosing poor insert performance in production? - Mailing list pgsql-novice

From Merlin Moncure
Subject Re: Diagnosing poor insert performance in production?
Date
Msg-id CAHyXU0y1JCp__qmDY9fXLqNUSRAREkG9QOPuL7bOgKZkBCC1Xw@mail.gmail.com
Whole thread Raw
In response to Re: Diagnosing poor insert performance in production?  (Wei Shan <weishan.ang@gmail.com>)
List pgsql-novice
On Wed, Jun 10, 2015 at 10:26 PM, Wei Shan <weishan.ang@gmail.com> wrote:
> Hi,
>
> Could you provide more details please for us to help.
>
> 1. table definition
> 2. insert command
> 3. explain plan

Yeah,  as always, please follow the guide here.
https://wiki.postgresql.org/wiki/Slow_Query_Questions

In particular, often the very first thing to determine is if you are
facing a storage (aka: i/o) based issue.  Storage problems have a very
different set of resolutions.

merlin


pgsql-novice by date:

Previous
From: Wei Shan
Date:
Subject: Re: Diagnosing poor insert performance in production?
Next
From: Jude DaShiell
Date:
Subject: import csv file into table