On May 21, 2015, at 10:25 AM, Keith <keith@keithf4.com> wrote:
>
> The problem with creating partitions on the fly via triggers, even ahead of when they're needed, is you run into BIG
contentionissues when you have high insert rates. One session will see it needs to create a new table, the next one
comesin before the table is made but either gets put into a wait state or outright fails when it goes to try and make
thenew table that's already there…
No failure, I handle the exception.
> It may not be an issue for you, but it's definitely something to keep in mind if you notice performance issues. :)
>
Right. Around midnight this db has very low activity.
--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice