I wasn't sure whether to post this in general, admin or performance but
since it is basically a performance question I went with performance.
I'm about to launch a new a website that is written using the Django web
framework and has PostgreSQL as the database server. Unfortunately I
can't affo
> How "up to date" do the counts need to be? If the count takes 4
> seconds, can you run it every minute and store the counts in a table for
> retrieval by the HTTP requests?
Now, I am storing integer value for filter in memory with timeout, but
in busy server, system sure crash without syste
Hello,
I am trying to optimize the count of files when I am using filters
(select by some row/s parameter/s)
In this case I think that postgresql really count all files.
Resulting in unacceptable times of 4 seconds in http server response.
Triggers+store in this case do not see very acceptable, b
