From: | "Catalin" <catalin(at)cyber(dot)ro> |
---|---|
To: | <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: [Performance] Daily Crash |
Date: | 2003-02-27 20:19:42 |
Message-ID: | 00be01c2de9d$8fd8b150$0201a8c0@catalin |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
how often should i run VACUUM to keep the thing tunned ?
Catalin
----- Original Message -----
From: philip johnson
To: Catalin ; pgsql-performance(at)postgresql(dot)org
Sent: Thursday, February 27, 2003 8:51 PM
Subject: RE: [PERFORM] [Performance] Daily Crash
pgsql-performance-owner(at)postgresql(dot)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(at)postgresql(dot)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(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Mayer | 2003-02-28 01:51:13 | Re: OIDs as keys |
Previous Message | philip johnson | 2003-02-27 18:51:01 | Re: [Performance] Daily Crash |