Re: Why Postgres doesn't use TID scan?

From: Vladimir Ryabtsev <greatvovan(at)gmail(dot)com>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Why Postgres doesn't use TID scan?
Date: 2018-12-18 02:40:49
Message-ID: CAMqTPq=Ezo21P5ToyfA9Nu0N7LiTm2GzTRJPt5CU3CCp1n4-_g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

OK, good to know.
I saw some timeout errors in the code writing to the log table during my
DELETE and decided they are relevant. Probably they had nothing to do with
my actions, need to investigate.
Thanks anyway.

Best regards,
Vlad

пн, 17 дек. 2018 г. в 18:32, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:

>
> DELETE doesn't lock the whole table. What problem are you actually
> facing?
>
>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Kirkwood 2018-12-18 03:10:50 Re: pgbench results arent accurate
Previous Message Tom Lane 2018-12-18 02:32:51 Re: Why Postgres doesn't use TID scan?