Re: [GENERAL] Upgrading from 9.2 to 9.3 causes performance degradation

2014-03-25 Thread Alfonso Afonso
it will at least rule out a bunch of > possibilities for the source of the problem. > > Cheers, > > Jeff > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general Alfonso Afonso

Re: [GENERAL] Transparent exchange BDE from Oracle to PostgreSQL

2014-02-02 Thread Alfonso Afonso
>> otherwise drivers are not added to Windows registry (I hate it). >> I appreciate your insights and your time. >> >> Regards, >> >> Edson >> >> >> > Possibly you could consider up grading to Linux first? > (Not being entirely faceti

Re: [GENERAL] Best practice on inherited tables

2013-05-17 Thread Alfonso Afonso
doing this for me but wondering whether > there might be a better way. > > Cheers, > Frank > > BTW: Using Postgres 9.2 and up > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://ww

Re: [GENERAL] using text search

2013-04-23 Thread Alfonso Afonso
El 23/04/2013, a las 11:24, Rafał Pietrak escribió: > W dniu 04/22/2013 08:43 PM, Alfonso Afonso pisze: >> I forgot to say that the function is "position ( txtseach in txtcomplete)" :) >> >> Bye > > > Alfonso, thenx > > But if I may: How can I

Re: [GENERAL] using text search

2013-04-22 Thread Alfonso Afonso
I forgot to say that the function is "position ( txtseach in txtcomplete)" :) Bye El 22/04/2013, a las 19:36, Alfonso Afonso escribió: > And using substring function? Do you have the same results? > > I understand your arguments about normalization but, as you know, BNF

Re: [GENERAL] using text search

2013-04-22 Thread Alfonso Afonso
t;> could obtain bizarre results and consume a lot of resources, but my >> approximation to your problem > Alfonso Afonso (personal)

Re: [GENERAL] using text search

2013-04-22 Thread Alfonso Afonso
mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general Alfonso Afonso (personal) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help

2013-04-18 Thread Alfonso Afonso
BMC Software > CTM&D Business Unit > DBA Team > 972-52-4286-282 > yuval_so...@bmc.com > > > > > > Alfonso Afonso (personal)

Re: [GENERAL] Emulating trigger BEFORE SELECT behavior

2013-04-18 Thread Alfonso Afonso
ds, > > Atri > > -- > Regards, > > Atri > l'apprenant > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general Alfonso Afonso (person

Re: [GENERAL] SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object

2013-04-17 Thread Alfonso Afonso
ApplicationFilterChain.java:206) > at > org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176) > at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) > > Do i have to set tcp _keepalive * paramter to less sec, or need to kill the > idle