n failed to break deadlock instead of
vacuum full table, how about this lock upgrade solution?
For example: we can enlarge the 'DeadlockTimeout' for vacuum full table
transaction to avoid deadlock check.
Jinyu Zhang
regards
At 2015-10-16 23:04:51, "Robert Haas" wrote
t you can pass it as NULL in the first call and then
>> >>>>followup calls reuse the one allocated in the first call.
>> Jinyu: the memory is allocated from perRangeCxt and perRangeCxt will be
>> reset in loop,
>> so this way don't work.
>
&
>>it's approach to this is to summarily kill anything that attempts DDL on a
>>table being repacked.
Why? I am confused with it. Could you please explain this?
Jinyu Zhang
thanks
At 2015-10-12 23:46:12, "Jim Nasby" wrote:
>On 10/11/15 6:55 AM, Jinyu wrote:
&
the concurency of vacuum full/cluster and
select statement on the same relation?
Jinyu Zhang,
thanks
At 2015-10-10 23:34:41, "Tom Lane" wrote:
>Jinyu writes:
>> Proposal: vacuum full table takes an ExclusiveLock on relation instead of
>> AccessExclusiveLock at
tion steps of cluster table is similar to vacuum
full table. The select statement is safe before cluster table call function
"finish_heap_swap".
Please let me know if I miss something.
Jinyu Zhang
thanks
AR(44) NOT NULL);
copy lineitem from '/home/jinyu/mywork/dbgen/lineitem.tbl' delimiter '|';
create index brinLineitem on lineitem using brin(L_ORDERKEY)
with(pages_per_range = 1);
Jinyu Zhang
网易考拉iPhone6s玫瑰金5288元，现货不加价
patch_optimize_mem
Description: Binary data
--
AR(44) NOT NULL);
copy lineitem from '/home/jinyu/mywork/dbgen/lineitem.tbl' delimiter '|';
create index brinLineitem on lineitem using brin(L_ORDERKEY)
with(pages_per_range = 1);
Jinyu Zhang
rn;
440 }
441 LockBuffer(buf, BUFFER_LOCK_EXCLUSIVE);
442 page = BufferGetPage(buf);
443
444 if (needLock)
445 UnlockRelationForExtension(irel, ExclusiveLock);
446 }
Jinyu,
regards
I think sort by string column is lower during merge join, maybe comparing
function in sort need be refined to save some cycle. It’s the hot function when
do sort.
Heikki Linnakangas 编写：
>On 01/27/2014 07:03 PM, Amit Kapila wrote:
>> I have tried to improve algorithm in another way so that w
