[GENERAL] psql is very slow

2006-02-24 Thread Michal Merta
Hi all, I have a psql7.3.4, apache 2.0.40, perlv5.8.0. Database is pretty big, (dump is about 100Megs). But all the operations are very, veryslow. 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

Re: [GENERAL] psql is very slow

2006-02-24 Thread Sean Davis
On 2/22/06 10:23 AM, Michal Merta [EMAIL PROTECTED] wrote: 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

Re: [GENERAL] psql is very slow

2006-02-24 Thread A. Kretschmer
am 22.02.2006, um 16:23:16 +0100 mailte Michal Merta folgendes: 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. - 7.3 is very, very old, newer verions are much faster! - runs vacuum! -

Re: [GENERAL] psql is very slow

2006-02-24 Thread Christopher Browne
Oops! [EMAIL PROTECTED] (Michal Merta) was seen spray-painting on a wall: 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