On Sun, Oct 23, 2005 at 00:14:23 -0400,
[EMAIL PROTECTED] wrote:
> Hey all.
>
> Please point me to a place I should be looking if this is a common
> question that has been debated periodically and at great length
> already. :-)
You probably want to read:
http://candle.pha.pa.us/main/writings/pg
Hey all.
Please point me to a place I should be looking if this is a common
question that has been debated periodically and at great length
already. :-)
I have a complex query. It's a few Kbytes large, and yes, I've already
worked on reducing it to be efficient in terms of database design, and
mi
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 make heavy use of g
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
On 10/22/2005 04:15:25 PM, Kishore B wrote:
Can any you please suggest the best configuration to satisfy the above
requirements?
You've increased shared memory buffers, told the kernel
to allow more shared memory (lots), and otherwise increased
the parameters associated with memory?
If so yo
[please send replies to the list, not to me directly]
On Sun, Oct 23, 2005 at 03:19:39AM +0530, Kishore B wrote:
> *You definitely want to upgrade this if you can.
>
> > Memory : 2 GB
> *
> We can move upto 12 GB if need to be.
I was referring to your PostgreSQL version, not your RAM. More RAM
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.
/* S
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.
Martin Nickel wrote:
> On Tue, 18 Oct 2005 08:52:15 +0100, Richard Huxton wrote:
> > 3. Actually - are you happy that your general configuration is OK?
> We're running dual Opteron 244s with 4G of memory. The platform is
> Suse 9.3, 64 bit. The database is on a 3ware 9500S-8 sata raid controll
