Re: When should I worry?

2007/6/10, Alexander Staubo <alex@purefiction.net>:
> On 6/10/07, Tom Allison <tom@tacocat.net> wrote:
> > The table itself is small (two columns: bigint, int) but I'm wondering when I'll
> > start to hit a knee in performance and how I can monitor that.
>
> You don't say anything about what the data is in the table or what
> queries you run against it, so there's not much here to give advice
> about.
>
> For the monitoring, however, you can log your queries along with
> timings and timestamps, and copy them into a tool like R to
> statistically analyze your performance over time. You will be able to
> predict the point at which your system will be too slow to use, if
> indeed the performance degradation is expontential.

Could you please share some details about this "tool like R"? Maybe
some links or usage examples?

TIA.



--
Filip Rembiałkowski