|
Hi I
am new at postgres and I'm having performance issues. I
am running on postgres 7.4.6 on a pineapp with 512MB RAM. I
did a database vacuum analyze and rebuild my indexes. When
I perform queries on tables of 2M-10M of rows it takes several minutes and I
see at sar and top that the cpu and memory is heavily used. I
would be glad for guidance on server parameters or other configurations which
would help. 10x.
|
