It'd be helpful if posted with the EXPLAIN of the slow running queries on the respective table.
cool.
L.
On 4/9/06, Doron Baranes <doron.baranes@xxxxxxxxxxx> wrote:
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.
