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.
Doron.
