[GENERAL] psql is very slow

[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 Athlon(tm) XP 1800+

Thanks.
Regards, Michal

Re: [GENERAL] psql is very slow

[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 :))

I assume that by psql you mean postgresql?

You'll probably have to be more specific about what you are doing, what your
database is like and how it is used, what you want to change, and what kinds
of time you are talking about.

Sean



---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match

Re: [GENERAL] psql is very slow

[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!
- use explain
- tell us your slow querys

You are from germany? We have a german mailing list too.


HTH, Andreas
-- 
Andreas Kretschmer(Kontakt: siehe Header)
Heynitz:  035242/47215,  D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===Schollglas Unternehmensgruppe=== 

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org

Re: [GENERAL] psql is very slow

[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 the database :))

Well, have you read the manual to follow the maintenance directions
that are recommended?

You're running a rather old version; 7.3 was neat enough stuff a
couple of years ago, but there have been several substantially
improved major versions since then.  An upgrade would seem wise.
-- 
let name=cbbrowne and tld=gmail.com in name ^ @ ^ tld;;
http://cbbrowne.com/info/slony.html
When marriage is outlawed, only outlaws will have inlaws. 

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq