upgrade from 8.1 ?
Please let me know your suggestions.
Regards
Shiva Raman .
On Fri, Sep 25, 2009 at 8:52 PM, Craig James wrote:
> Gerhard Wiesinger wrote:
>
>> Hello Craig,
>>
>> Are you sure this is correct?
>>
>> The test program (see below) with auto
As suggested, i had changed the log_statement='ddl' and now it is logging
only
the ddl statements . thanks for the tip.
Can i delete the old log files in pg_log after backing up as zip archive ?
is it neccesary to keep those log files ?
Regards
Shiva Raman
>
> 2009/9/25 Grz
am database dumps every day .
pg_xlog and pg_clog has nearly less than 25 Mb of data only.
Regds
Shiva Raman
> very small network resources).
>
> And IHMO killing database processes isn't a solution to your problem.
> Database server should nearly never be restarted.
>
> Ciao,
> Gerhard
>
Regards
Shiva Raman
>
>
>
of them are showing S(Sleep ) status. Please suggest
anyway i can resolve this idle transaction issue.
Regards
Shiva Raman
cer would considerably reduce the*
*burden on your system.*
I am already using connection pooling in tomcat web server, so installing
pgpool
will help enhancing the performance ?Any changes i have to do in my
application to
include pgpool?
Regds
Shiva raman
#x27;
lc_numeric = 'en_US.UTF-8'
lc_time = 'en_US.UTF-8'
Any modifications i have to do in this values ?
Regds
Shiva Raman .
x27;en_US.UTF-8'
lc_numeric = 'en_US.UTF-8'
lc_time = 'en_US.UTF-8'
*User Access*
Total Number of Users is 500
Maximum number of Concurrent users will be 500 during peak time
Off Peak time the maximum number of concurrent user will be around 150 to
200.
Please let me know your suggestions to improve the performance.
Regards
Shiva Raman
