Question on disk contention

From: "Charles Clavadetscher" <clavadetscher(at)swisspug(dot)org>
To: "'Melvin Davidson'" <melvin6925(at)gmail(dot)com>
Cc: "'pgsql-generallists(dot)postgresql(dot)org'" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Question on disk contention
Date: 2018-05-31 05:13:55
Message-ID: 024f01d3f89e$323e20d0$96ba6270$@swisspug.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Melvin

As an answer to a previous post you wrote:

"Also, your main problem is that when you have two exact same queries executing at the same time, they will cause contention in
the disk, and neither one will make much progress."

Could you elaborate a little more on the meaning of "contention in the disk"?
What is it that happens?

Thank you and have a good day.
Regards
Charles

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Federico Di Gregorio 2018-05-31 07:22:52 Re: License Question
Previous Message tango ward 2018-05-31 04:45:27 Re: Insert UUID GEN 4 Value