Comment 5 for bug 660291
Revision history for this message
| Stuart Bishop (stub) wrote Re: [Bug 660291] Re: inconsistent performance between staging and prod | #5 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
a60fb26
(Get the code!)
On Tue, Jan 17, 2012 at 5:26 AM, Robert Collins
<email address hidden> wrote:
> Ok, we will need RT for the hardware aspect
If staging is brought up to spec to match production, that causes
other issues - staging will always perform better production as there
is much less concurrency.
Is the goal here purely to get the planner to plan the same way?
Again, I don't think it can ever be identical due to the difference in
concurrency (production will think tables are hot and staging will
not), but we can lie in our tuning parameters - performance on staging
will suffer as the planner is not planning to actual hardware, but the
plans will be closer.
--
Stuart Bishop <email address hidden>