Re:

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(dot)baranes(at)dbnet(dot)co(dot)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.
>