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.
|
- [PERFORM] Doron Baranes
- Re: [PERFORM] Luckys
- Re: [PERFORM] Ragnar
- Re: [PERFORM] Doron Baranes
- Re: [PERFORM] Ragnar
- [PERFORM] Adam Palmblad
- [PERFORM] Jim Nasby
- Re: [PERFORM] Steinar H. Gunderson
- Re: [PERFORM] Ian Westmacott
- Re: [PERFORM] Chris Hoover
- Re: [PERFORM] Ian Westmacott