Postgres Pro
Downloads
Home   >   mailing lists

Re: Why Postgres doesn't use TID scan? - Mailing list pgsql-performance

From Vladimir Ryabtsev
Subject Re: Why Postgres doesn't use TID scan?
Date
Msg-id CAMqTPq=Ezo21P5ToyfA9Nu0N7LiTm2GzTRJPt5CU3CCp1n4-_g@mail.gmail.com
Whole thread Raw
In response to Re: Why Postgres doesn't use TID scan?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view
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@sss.pgh.pa.us>:

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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Why Postgres doesn't use TID scan?
Next
From: Mark Kirkwood
Date:
Subject: Re: pgbench results arent accurate