> I'd be tempted to bump it up to 2.0 or 2.5 since data is on a single
> disk (sequential scans *will* be faster than an index scan), but you
> would need to run a benchmark on your disk to see if that is right.

I just set it to 2.5.  What kind of benchmark can I run?

> Every monitor is updated every 5 minutes?

Yes.  Actually the customer can detween between every 5-60 minutes but for a
worst case scenario I set them to be 5 minutes for stress testing.  Note
that all 1,500 monitors are not updated at the same time, they're evenly
distributed.

> Your reports. Are they always on the most recent date, or do they vary
> in time.  Are queries distributed against old data as much as the new
> stuff?

So far my plan is to have only the current month of data in the database, so
at the first of every month I'll drop the old data.  There are two sources
of this monstrous query:

the webapp lets users make the query for the current day.
the reporting app makes the query for the prior day, the current week, and
month to date.

Between the two the queries are pretty evenly distributed.




---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to