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
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
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&#
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
>
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
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
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.
Dear Sir/Mam,
Can I have technical documentation for configuration of PgPool?
