Postgres Pro
Downloads
Home   >   mailing lists

psql is very slow - Mailing list pgsql-general

From Michal Merta
Subject psql is very slow
Date
Msg-id d343fff60602220723p6f11eef0l43e4e5cbb32e0f@mail.gmail.com
Whole thread Raw
Responses Re: psql is very slow  (Sean Davis <sdavis2@mail.nih.gov>)
Re: psql is very slow  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: "fritz-bayer@web.de"
Date:
Subject: setting LC_NUMERIC
Next
From: "Amrit Angsusing"
Date:
Subject: Could DBmirror be done with the mechine using RPM installation instaed of souce code [tar.gz] ?