Re:

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux