Hi All,
I am Kishore doing freelance development of J2EE applications.
We switched to use Postgresql recently because of the advantages it has over other commercial databases. All went well untill recently, untill we began working on an application that needs to maintain a huge database.
I
Hi All,
I am Kishore doing freelance development of J2EE applications.
We switched to use Postgresql recently because of the advantages it has over other commercial databases. All went well untill recently, untill we began working on an application that needs to maintain a huge database.
I
On Sun, Oct 23, 2005 at 02:45:25AM +0530, Kishore B wrote:
Database *:* Postgresql 7.3
You definitely want to upgrade this if you can.
Memory : 2 GB
For 2GB of RAM, your effective_cache_size (10) is a bit low (try doubling
it), and sort_mem (2048) is probably a bit too low as well.
/*
Kishore B [EMAIL PROTECTED] writes:
Even a basic query like select count(*) from bigger_table is
taking about 4 minutes to return.
You do realize that select count(*) requires a full table scan in
Postgres? It's never going to be fast.
If that's not where your performance problem really is,
Hi Gunderson,
Can I set the effective_cache_size to 20?
Yes, that should work fine.
Do you mean that I can set the effective_cache_size to 1.5 GB out of 2GB Memory that I have in the current system?
Can I set the sort_memory to 3072? We need to generate reports which makeheavy use of group