From: | Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: [EXTERNAL] Re: Inserts and bad performance |
Date: | 2021-11-28 21:23:23 |
Message-ID: | 70e9efe6-c771-eeb3-6c03-35911e7052e5@archidevsys.co.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)gmail(dot)com>
> *Sent:* Wednesday, November 24, 2021 10:58 PM
> *To:* pgsql-general(at)lists(dot)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Markus | 2021-11-29 06:23:10 | Re: Match 2 words and more |
Previous Message | Peter J. Holzer | 2021-11-28 11:29:37 | Re: Match 2 words and more |