These are chat archives for ManageIQ/manageiq/performance

22nd
Jan 2016
Keenan Brock
@kbrock
Jan 22 2016 14:52
@djberg96 Heh, none of those are the solutions I'd pick
I agree, don't do null: false, default: true until that column is populated
Daniel Berger
@djberg96
Jan 22 2016 14:53
Oh? What would you do?
Keenan Brock
@kbrock
Jan 22 2016 14:53
you add the column/default, you set the column, then you modify it
I'd do an update where the value is null
but use a rowid or something to populate
in sql
hmm - need a google second on this one
Jason Frey
@Fryguy
Jan 22 2016 14:54
@matthewd I'm surprised because that was supposed to be solved by the bitmap GC stuff in Ruby 2.0
And it seems something else is going around that
Keenan Brock
@kbrock
Jan 22 2016 14:59
@djberg96 ooh, they just want nil?
loop do
  count = connection.update("update notifications set text_message = false, call_phone = false 
      where text_message = false limit 10000")
  break if count != 10000
end
Jason Frey
@Fryguy
Jan 22 2016 14:59
Probably the bump of the generation number