2007/6/10, Alexander Staubo <[EMAIL PROTECTED]>:
On 6/10/07, Tom Allison <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
