On Wed, Jun 10, 2015 at 10:26 PM, Wei Shan <weishan(dot)ang(at)gmail(dot)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