From: "Doron Baranes" <doron(dot)baranes(at)dbnet(dot)co(dot)il>
To: <pgsql-performance(at)postgresql(dot)org>
Subject:
Date: 2006-04-09 10:47:52
Message-ID: 0BA77301DFF4B24C9C5DAA74138BF95001E1E7@exchange-1.dbnet.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

Responses

  • Re: at 2006-04-09 10:42:36 from Luckys
  • Re: at 2006-04-09 11:10:16 from Ragnar

Browse pgsql-performance by date

  From Date Subject
Next Message Ragnar 2006-04-09 11:10:16 Re:
Previous Message Luckys 2006-04-09 10:42:36 Re: