On 22 March 2014 05:32, Tom Lane t...@sss.pgh.pa.us wrote:
Thom Brown t...@linux.com writes:
Is it necessary for a partial index that doesn't include the row to be
involved in locking?
Yes. You can't determine whether the index needs to get a new entry
without examining its metadata, and
Thom Brown t...@linux.com writes:
On 22 March 2014 05:32, Tom Lane t...@sss.pgh.pa.us wrote:
Yes. You can't determine whether the index needs to get a new entry
without examining its metadata, and that's what the lock is mainly about.
I see. Why does this apply to deletes too?
The executor
On 22 March 2014 15:04, Tom Lane t...@sss.pgh.pa.us wrote:
Thom Brown t...@linux.com writes:
On 22 March 2014 05:32, Tom Lane t...@sss.pgh.pa.us wrote:
Yes. You can't determine whether the index needs to get a new entry
without examining its metadata, and that's what the lock is mainly about.
On 3/21/14, 7:59 PM, Vik Fearing wrote:
On 03/22/2014 01:43 AM, Thom Brown wrote:
Hi,
I've created a table with 1000 partial indexes. Each one matches
exactly one row based on the predicate WHERE id = value.
However, when I perform an UPDATE of a single row in a transaction,
I've noticed
On 22 March 2014 16:28, Jim Nasby j...@nasby.net wrote:
On 3/21/14, 7:59 PM, Vik Fearing wrote:
On 03/22/2014 01:43 AM, Thom Brown wrote:
Hi,
I've created a table with 1000 partial indexes. Each one matches
exactly one row based on the predicate WHERE id = value.
However, when I perform
Hi,
I've created a table with 1000 partial indexes. Each one matches
exactly one row based on the predicate WHERE id = value.
However, when I perform an UPDATE of a single row in a transaction,
I've noticed that all those partial indexes show up in pg_locks with
RowExclusiveLock.
Only 2 of
On 03/22/2014 01:43 AM, Thom Brown wrote:
Hi,
I've created a table with 1000 partial indexes. Each one matches
exactly one row based on the predicate WHERE id = value.
However, when I perform an UPDATE of a single row in a transaction,
I've noticed that all those partial indexes show up in
On 22 March 2014 00:59, Vik Fearing vik.fear...@dalibo.com wrote:
On 03/22/2014 01:43 AM, Thom Brown wrote:
Hi,
I've created a table with 1000 partial indexes. Each one matches
exactly one row based on the predicate WHERE id = value.
However, when I perform an UPDATE of a single row in a
Thom Brown t...@linux.com writes:
Is it necessary for a partial index that doesn't include the row to be
involved in locking?
Yes. You can't determine whether the index needs to get a new entry
without examining its metadata, and that's what the lock is mainly about.
The only possible