[GENERAL] PgPool Configuration Document required

Dear Sir/Mam, Can I have technical documentation for configuration of PgPool?

Re: [GENERAL] PgPool Configuration Document required

executed on slave server. Thanks, Jimit Amin On 30 Jun 2015 21:52, "Joshua D. Drake" wrote: > > On 06/30/2015 09:05 AM, Jimit Amin wrote: > >> Dear Sir/Mam, >> >> Can I have technical documentation for configuration of PgPool? >> >> > http://www.

[GENERAL] String match function required like utl_match in oracle

Hello, I want to compare 2 string and want result like how much percentage or how much part string is compared. Can I know any option like utl_match in oracle Jimit Amin

[GENERAL] could not fork new process for connection: Resource temporarily unavailable

ello, I have heavy transaction load production database 9.3 PPAS .Today Database is not able to give new process. I checked pg_stat_activity , there are so many transaction in waiting stage because of one procedure and lock on one table (Code inside procedure) SELECT cnt FROM tabl

Re: [GENERAL] String match function required like utl_match in oracle

Thanks, It is somewhat useful. Jimit Amin On Sat, Jul 4, 2015 at 3:51 PM, Charles Clavadetscher < clavadetsc...@swisspug.org> wrote: > Or maybe even better: > > http://www.postgresql.org/docs/9.4/static/fuzzystrmatch.html > > Search for Levenshtein. > > Bye >

Re: [GENERAL] regexp_matches for digit

Rames, Hope this will be useful http://www.postgresql.org/docs/9.1/static/functions-string.html Jimit Amin On Thu, Jul 9, 2015 at 9:54 PM, Ramesh T wrote: > Hi, > in oracle regexp_like(entered > date,'[[:digit:]]{4}-[[:digit:]]{2}-[[:digit:]]{2}','i&#

[GENERAL] PostgreSQL conf parameter setting

Dear all, Can I know normal, aggressive, best parameter settings for PostgreSQL.conf file for particular hardware. Like Linux x86_64 , 8 GB Ram , Linux x86_64 , 126 GB Ram Thanks and Regards Jimit Amin

Re: [GENERAL] Table using more disk space than expected

Could you please check this after running Vacuum Analyze. I know there may not be big difference. As par my analysis this is free space available in table but not free in respect to server space. Like table contains 3 type of space. 1 Live row space 2 Dead row space 3 Free space available for tha