Re: [HACKERS] merging some features from plpgsql2 project

2017-01-09 Thread Pavel Stehule
2017-01-09 0:39 GMT+01:00 Jim Nasby : > On 1/7/17 11:44 PM, Pavel Stehule wrote: > >> This is not overloading of SQL command - it is like annotations. It is >> smart idea, so I was not surprised if ANSI/SQL reuses it. >> > > SHas ANSI declared that they will NEVER

Re: [HACKERS] Block level parallel vacuum WIP

2017-01-09 Thread Simon Riggs
On 9 January 2017 at 08:48, Masahiko Sawada wrote: > I had not considered necessity of dead lock detection support. It seems like a big potential win to scan multiple indexes in parallel. What do we actually gain from having the other parts of VACUUM execute in parallel?

Re: [HACKERS] merging some features from plpgsql2 project

2017-01-09 Thread Pavel Stehule
2017-01-09 1:10 GMT+01:00 Jim Nasby : > On 1/8/17 12:03 AM, Pavel Stehule wrote: > >> BTW, I do wish you could change the label of the scope that >> arguments went into, so that you could use that label to refer >> to function parameters. If we

Re: [HACKERS] Block level parallel vacuum WIP

2017-01-09 Thread Masahiko Sawada
On Sat, Jan 7, 2017 at 2:47 PM, Amit Kapila wrote: > On Fri, Jan 6, 2017 at 11:08 PM, Masahiko Sawada > wrote: >> On Mon, Oct 3, 2016 at 11:00 AM, Michael Paquier >> wrote: >>> On Fri, Sep 16, 2016 at 6:56 PM, Masahiko

Re: [HACKERS] pg_stat_lwlock wait time view

2017-01-09 Thread Haribabu Kommi
[ Re sending to Hackers as the earlier mail failed to deliver to Hackers mailing list] On Mon, Jan 9, 2017 at 4:13 PM, Haribabu Kommi wrote: > > > On Thu, Aug 25, 2016 at 2:46 PM, Haribabu Kommi > wrote: > >> On Thu, Aug 25, 2016 at 6:57 AM,

Re: [HACKERS] merging some features from plpgsql2 project

2017-01-09 Thread Pavel Stehule
2017-01-09 0:37 GMT+01:00 Jim Nasby : > On 1/8/17 2:52 AM, Joel Jacobson wrote: > >> And please kill all these GUCs ideas. The best thing with PostgreSQL >> is the natural expected behaviour of the default configuration. >> Contrary to MySQL where you have to enable lots

Re: [HACKERS] Declarative partitioning - another take

2017-01-09 Thread amul sul
Hi, I got server crash due to assert failure at ATTACHing overlap rang partition, here is test case to reproduce this: CREATE TABLE test_parent(a int) PARTITION BY RANGE (a); CREATE TABLE test_parent_part2 PARTITION OF test_parent FOR VALUES FROM(100) TO(200); CREATE TABLE test_parent_part1(a

Re: [HACKERS] macaddr 64 bit (EUI-64) datatype support

2017-01-09 Thread Haribabu Kommi
On Fri, Jan 6, 2017 at 3:51 PM, Vitaly Burovoy wrote: > On 1/4/17, Haribabu Kommi wrote: > > On Tue, Nov 29, 2016 at 8:36 PM, Haribabu Kommi < > kommi.harib...@gmail.com> > > wrote: > >> Updated patch attached with added cast function from

<    1   2