psql is very slow

From: "Michal Merta" <michal(dot)merta(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: psql is very slow
Date: 2006-02-22 15:23:16
Message-ID: d343fff60602220723p6f11eef0l43e4e5cbb32e0f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I have a psql 7.3.4, apache 2.0.40, perl v5.8.0. Database is pretty big,
(dump is about 100Megs).
But all the operations are very, very slow.
Is any possibility to make postgresql more quick? (don't tell me to cut the
database :))

OS version: 2.4.20-gentoo-r7
RAM: 512MB
CPU:i686 AMD Athlon(tm) XP 1800+

Thanks.
Regards,
Michal

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Prestation3.EXPLOITATION 2006-02-22 15:29:09 Réf. : Re: Out of memory using ora2pg
Previous Message jason.ctr.alburger 2006-02-22 15:22:39 Fw: ecpg error --> DbPg_cre_sect_buf.pgc:1334: ERROR: syntax error at or near "RELEASE"