led 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" <robertmh...@
;>>>the pointers, so that 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 d
>>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" <jim.na...@bluetreble.com> wrote:
>O
oncurency of vacuum full/cluster and
select statement on the same relation?
Jinyu Zhang,
thanks
At 2015-10-10 23:34:41, "Tom Lane" <t...@sss.pgh.pa.us> wrote:
>Jinyu <call_ji...@126.com> writes:
>> Proposal: vacuum full table takes an ExclusiveLock on relation in
o 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
) 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
) 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
--
Sent via pgsql-hackers mailing
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 hlinnakan...@vmware.com编写:
On 01/27/2014 07:03 PM, Amit Kapila wrote:
I have tried to improve algorithm in