Re: [HACKERS] Improve the concurency of vacuum full table and select statement on the same relation

2015-10-19 Thread Jinyu
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...@

Re: [HACKERS] Patch: Optimize memory allocation in function 'bringetbitmap'

2015-10-16 Thread Jinyu Zhang
;>>>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

Re: [HACKERS] Improve the concurency of vacuum full table and select statement on the same relation

2015-10-13 Thread Jinyu
>>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

Re: [HACKERS] Improve the concurency of vacuum full table and select statement on the same relation

2015-10-11 Thread Jinyu
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

[HACKERS] Improve the concurency of vacuum full table and select statement on the same relation

2015-10-10 Thread Jinyu
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

[HACKERS] BRIN Scan: Optimize memory allocation in function 'bringetbitmap'

2015-09-27 Thread 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

[HACKERS] Patch: Optimize memory allocation in function 'bringetbitmap'

2015-09-27 Thread 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

[HACKERS] Did we forget to unpin buf in function "revmap_physical_extend" ?

2015-09-11 Thread 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

Re: [HACKERS] Performance Improvement by reducing WAL for Update Operation

2014-01-28 Thread Jinyu
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