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
On 07/04/2015 12:19 PM, Jimit Amin wrote:
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
Thanks for the suggestion. I read that some people do use that strategy for
maintenance sometimes but it's no feasible in this scenario.
I would have to disallow new connections AND kill all existing connections
(as there would be an existing connection pool), but this won't have the
same impact
On 7/4/2015 10:49 AM, Filipe Pina wrote:
Terminating all sessions will break every other transaction (except
for the one doing it). Locking database will put all the other on hold.
As we're talking about quick/instant operations on hold will have
impact on performance but won't cause anything
On 07/04/2015 10:49 AM, Filipe Pina wrote:
Thanks for the suggestion. I read that some people do use that strategy
for maintenance sometimes but it's no feasible in this scenario.
I would have to disallow new connections AND kill all existing
connections (as there would be an existing
I have a very simple query that is giving me some issues due to the size of the
database and the number of requests I make to it in order to compile the report
I need:
A dumbed down version of the table and query:
CREATE TABLE a_to_b (
id_a INT NOT NULL REFERENCES
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
On 07/03/2015 06:28 PM, john.tiger wrote:
have tables with : create table mydocs (id serial primary key, data jsonb)
when I do a select data from mydocs it comes back as {data: {my jsonb
fields}} which then gets passed into a template - don't want to have to
keep using %= article.data.name %
Or maybe even better:
http://www.postgresql.org/docs/9.4/static/fuzzystrmatch.html
Search for Levenshtein.
Bye
Charles
On 7/4/2015 11:50, Jimit Amin wrote:
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