pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Catalin <catalin@cyber.ro>
To: pgsql-performance@postgresql.org
Subject: Re: [Performance] Daily Crash
Date: Thu, 27 Feb 2003 22:19:42 +0200
Message-ID: <00be01c2de9d$8fd8b150$0201a8c0@catalin> (raw)
References: <NDBBJLHHAKJFNNCGFBHLMEKOEMAA.philip.johnson@atempo.com>

how often should i run VACUUM to keep the thing tunned ?

Catalin

----- Original Message ----- 
From: philip johnson 
To: Catalin ; pgsql-performance@postgresql.org 
Sent: Thursday, February 27, 2003 8:51 PM
Subject: RE: [PERFORM] [Performance] Daily Crash


pgsql-performance-owner@postgresql.org wrote:
> i have php 4.2.3
> i use pg_pConnect and no pg_Close.
> 
> thanks for yours advices.
> i will upgrade to postgresql 7.2.3 asap
> and see if there are improvments !
> 
> thanks again !
> 
> Catalin
> 
> ----- Original Message -----
> From: Aspire Something
> To: pgsql-performance@postgresql.org
> Sent: Thursday, February 27, 2003 4:44 PM
> Subject: Re: [PERFORM] [Performance] Daily Crash
> 
> 
> Dear Catalin,
> 
> 
> What I understand from ur post is,
> 1. U are using PHP for connection. what version ??? assuming u are on
> PHP version >4.2.X
> 2. Ur Postgresql server is not tuned to handle loads.
> 
> What U can try is ......
> 
> 1.Make sure  that ur PHP scripts close the connection when
> transaction is complete (HOW??? see after pg_connect
> 
> U  see a pg_close function of PHP)
>         a. Use pg_pconnect  and forget about pg_connect and pg_close
> 2. Increse the limit of connection to be made to PostgreSQL  this can
> be done as said by Shridhar the default is 32
> 3. For God sake Upgrade to PostgreSQL 7.3.2 and PHP 4.3.1 you are
> missing a lot with that old versions.
> 
> 
> 
> Regards,
> V Kashyap
> 
> ================================
> Some people think it's holding on that makes one strong;
>  sometimes  it's letting go.
> ================================
> 
> 
> 
> ---------------------------(end of
> broadcast)--------------------------- TIP 2: you can get off all
>     lists at once with the unregister command (send "unregister
> YourEmailAddressHere" to majordomo@postgresql.org) 
> 
> ---------------------------(end of
> broadcast)--------------------------- TIP 5: Have you checked our
> extensive FAQ? 
> 
> http://www.postgresql.org/users-lounge/docs/faq.html

you can use no persistent link to database
see in php.ini

pgsql.allow_persistent = Off



view thread (11+ messages)  latest in thread

Message-ID: <00be01c2de9d$8fd8b150$0201a8c0@catalin>
Permalink:  ../00be01c2de9d$8fd8b150$0201a8c0@catalin/
Also on:    postgresql.org/message-id/00be01c2de9d$8fd8b150$0201a8c0@catalin

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: catalin@cyber.ro
  Subject: Re: [Performance] Daily Crash
  In-Reply-To: <00be01c2de9d$8fd8b150$0201a8c0@catalin>
  References: <NDBBJLHHAKJFNNCGFBHLMEKOEMAA.philip.johnson@atempo.com> <00be01c2de9d$8fd8b150$0201a8c0@catalin>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox