Re: [HACKERS] Follow up to irc on CREATE INDEX vs. maintenance_work_mem on 9.3

2014-11-26 Thread Alex Shulgin
Andrew Gierth writes: >> "Alex" == Alex Shulgin writes: > > > Tom Lane writes: > >> Must've been my evil twin. > > Alex> Sorry, I must be under false impression that RhodiumToad is > Alex> *your* nick on #postgresql at freenode. I don't recall who > Alex> told me that, but I was pret

Re: [HACKERS] Follow up to irc on CREATE INDEX vs. maintenance_work_mem on 9.3

2014-11-26 Thread Andrew Gierth
> "Alex" == Alex Shulgin writes: > Tom Lane writes: >> Must've been my evil twin. Alex> Sorry, I must be under false impression that RhodiumToad is Alex> *your* nick on #postgresql at freenode. I don't recall who Alex> told me that, but I was pretty sure it's you. :-p ... what Peopl

Re: [HACKERS] Follow up to irc on CREATE INDEX vs. maintenance_work_mem on 9.3

2014-11-26 Thread Tom Lane
Alex Shulgin writes: > Tom Lane writes: >> Must've been my evil twin. > Sorry, I must be under false impression that RhodiumToad is *your* nick > on #postgresql at freenode. I don't recall who told me that, but I was > pretty sure it's you. :-p That's Andrew Gierth, I believe. I'm not much fo

Re: [HACKERS] Follow up to irc on CREATE INDEX vs. maintenance_work_mem on 9.3

2014-11-26 Thread Alex Shulgin
Tom Lane writes: > Stephen Frost writes: >> * Alex Shulgin (a...@commandprompt.com) wrote: >>> Tom, >>> >>> First of all, thanks for your help on IRC last time with that CREATE >>> INDEX memory consumption problem. > >> Doubt it was Tom, but if it was, wanna share what channel on IRC it was? >

Re: [HACKERS] Follow up to irc on CREATE INDEX vs. maintenance_work_mem on 9.3

2014-11-26 Thread Tom Lane
Stephen Frost writes: > * Alex Shulgin (a...@commandprompt.com) wrote: >> Tom, >> >> First of all, thanks for your help on IRC last time with that CREATE >> INDEX memory consumption problem. > Doubt it was Tom, but if it was, wanna share what channel on IRC it was? > :D Must've been my evil twi

Re: [HACKERS] Follow up to irc on CREATE INDEX vs. maintenance_work_mem on 9.3

2014-11-26 Thread Stephen Frost
Alex, * Alex Shulgin (a...@commandprompt.com) wrote: > Tom, > > First of all, thanks for your help on IRC last time with that CREATE > INDEX memory consumption problem. Doubt it was Tom, but if it was, wanna share what channel on IRC it was? :D > Now my question, is it feasible to back-patch th

[HACKERS] Follow up to irc on CREATE INDEX vs. maintenance_work_mem on 9.3

2014-11-26 Thread Alex Shulgin
Tom, First of all, thanks for your help on IRC last time with that CREATE INDEX memory consumption problem. As has been pointed out in a stackexchange answer to my question[1], it is indeed the limitation of pre-9.4 versions, but the limit is imposed on memtuples array, rather than total memory