[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [EXTERNAL] Re: Inserts and bad performance
From:       Gavin Flower <GavinFlower () archidevsys ! co ! nz>
Date:       2021-11-28 21:23:23
Message-ID: 70e9efe6-c771-eeb3-6c03-35911e7052e5 () archidevsys ! co ! nz
[Download RAW message or body]

On 28/11/21 17:17, Godfrin, Philippe E wrote:
>
> Right you are sir! I figured that out a few hours ago!
>
> pg
>
> *From:* Ron <ronljohnsonjr@gmail.com>
> *Sent:* Wednesday, November 24, 2021 10:58 PM
> *To:* pgsql-general@lists.postgresql.org
> *Subject:* [EXTERNAL] Re: Inserts and bad performance
>
> On 11/24/21 1:15 PM, Godfrin, Philippe E wrote:
>
> [snip]
>
>     I dropped the unique index , rebuilt the other indexes and no change.
>
>
> IMNSHO, this is the worst possible approach.  Drop everything *except* 
> the unique index, and then (if possible) sort the input file by the 
> unique key.   That'll increase buffered IO; otherwise, you're bopping 
> all around the filesystem.
>
> Using a bulk loader if possible would increase speeds
>
> -- 
> Angular momentum makes the world go 'round.
>
Please don't top post!


Cheers,
Gavin



[prev in list] [next in list] [prev in thread] [next in thread]