On Sat, Aug 18, 2012 at 1:05 AM, Bartel Viljoen <bar...@ncc.co.za> wrote:
> Dear mailing list.**** > > ** ** > > My current application make use of partitioning by creating a new child > table which holds transaction records for every month. I’ve notice that > after a couple of months depending on the hardware at some of our clients > the inserts become very slow. The reason memory. > How do you know that memory is the reason? What behavior or monitoring-tool output are you seeing that leads you to that conclusion? > I don’t want to delete old child tables even though they may be queried > seldom > If you did delete the old child tables, would it solve the problem? If the problem is showing up specifically on inserts, and the inserts are happening directly into the leading-edge partition, then older child tables shouldn't have anything to do with it. Cheers, Jeff
