T
TheMadDBA
Guest
You are better off putting mostly static lookup tables into the alternate buffer pool. You can size the -B2 to hold the entire working set and they will stay there once loaded until the DB restarts. No LRU activity to evict and reload pages. Leave the trans tables in the main buffer pool and it will keep as much of those tables as possible but it is possible to get it flushed out by huge queries. If you have enough memory to load everything that would be great but not usually the real world unless you have a smaller database. If you find that the main buffer is being flushed out then you can use the VSTs and something like ProTop to try and find the offending code and make sure the index usage is proper. If you don't have ProTop yet I would strongly suggest to download it. It will show you pretty much all of the meaningful metrics that the vast majority of Progress installs would ever need to look at.
Continue reading...
Continue reading...