Home > mailing lists

Re: - Mailing list pgsql-performance

From	Luckys
Subject	Re:
Date	April 9, 2006 10:42:41
Msg-id	b80d582c0604090342i365b2b10k4dde81bf725ac5f@mail.gmail.com Whole thread Raw
In response to	("Doron Baranes" <doron.baranes@dbnet.co.il>)
List	pgsql-performance

Tree view

It'd be helpful if posted with the EXPLAIN of the slow running queries on the respective table.

cool.

On 4/9/06, Doron Baranes <doron.baranes@dbnet.co.il> 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.

pgsql-performance by date:

From: "Doron Baranes"
Date: 09 April 2006, 09:47:40
Subject:

From: Ragnar
Date: 09 April 2006, 11:07:34
Subject: Re:

Re: - Mailing list pgsql-performance

Previous

Next