From: | Filip Rembiałkowski <plk(dot)zuber(at)gmail(dot)com> |
---|---|
To: | "Alexander Staubo" <alex(at)purefiction(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: When should I worry? |
Date: | 2007-06-11 16:52:59 |
Message-ID: | 92869e660706110952r3f8e8ad4w8890df351195b880@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2007/6/10, Alexander Staubo <alex(at)purefiction(dot)net>:
> On 6/10/07, Tom Allison <tom(at)tacocat(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Crawford | 2007-06-11 17:05:06 | Re: When should I worry? |
Previous Message | Shoaib Mir | 2007-06-11 15:44:41 | Re: Materializing the relation |