Re: [GENERAL] Receiving many more rows than expected

2014-05-09 Thread Adrian Klaver
On 05/09/2014 08:36 AM, David G Johnston wrote: Vincent de Phily wrote On Friday 09 May 2014 06:52:33 Adrian Klaver wrote: On 05/09/2014 05:36 AM, Vincent de Phily wrote: On Friday 09 May 2014 07:01:32 Tom Lane wrote: Vincent de Phily < vincent.dephily@ > writes: In case it changes any

Re: [GENERAL] Full text: Ispell dictionary

2014-05-09 Thread Tim van der Linden
Hi Oleg > btw, take a look on contrib/dict_xsyn, it's more powerful than > synonym dictionary. Sorry for the late reply...and thank you for the tip. I will check out xsyn soon. I am about to finish the third and final chapter of my full text series, but I could maybe write an "appendix" chapte

Re: [GENERAL] Receiving many more rows than expected

2014-05-09 Thread Adrian Klaver
On 05/09/2014 08:04 AM, Vincent de Phily wrote: On Friday 09 May 2014 06:52:33 Adrian Klaver wrote: Thanks to all for taking an interest so far, this bug is... weird. Yes weird. I tried to replicate your query to see if I could see anything similar. Tried it on 9.0.17 and 9.3.4 and could

Re: [GENERAL] Receiving many more rows than expected

2014-05-09 Thread Adrian Klaver
On 05/09/2014 08:14 AM, Vincent de Phily wrote: On Friday 09 May 2014 08:01:47 Adrian Klaver wrote: On 05/09/2014 01:45 AM, Vincent de Phily wrote: Before you grow suspicious of that conf_getint, the config is loaded once at program startup, and the overlarge results hapen together with normal

Re: [GENERAL] Enforce Symmetric Matrix

2014-05-09 Thread Randy Westlund
On Wed, May 07, 2014 at 04:07:22PM -0500, John McKown wrote: > On Wed, May 7, 2014 at 3:36 PM, Randy Westlund wrote: > > > I have a table with N (over 35k) rows. I need to compare each of > > those elements to every other element in the list, which is the > > handshake problem. > > > > This resu

Re: [GENERAL] Receiving many more rows than expected

2014-05-09 Thread David G Johnston
Vincent de Phily wrote > On Friday 09 May 2014 06:52:33 Adrian Klaver wrote: >> On 05/09/2014 05:36 AM, Vincent de Phily wrote: >> > On Friday 09 May 2014 07:01:32 Tom Lane wrote: >> >> Vincent de Phily < > vincent.dephily@ > > writes: >> >>> In case it changes anything, this is the uncut (but st

Re: [GENERAL] Receiving many more rows than expected

2014-05-09 Thread Vincent de Phily
On Friday 09 May 2014 08:01:47 Adrian Klaver wrote: > On 05/09/2014 01:45 AM, Vincent de Phily wrote: > > Before you grow suspicious of that conf_getint, the config is loaded once > > at program startup, and the overlarge results hapen together with normal > > results without having left the loop.

Re: [GENERAL] Receiving many more rows than expected

2014-05-09 Thread Adrian Klaver
On 05/09/2014 01:45 AM, Vincent de Phily wrote: On Thursday 08 May 2014 16:56:25 Adrian Klaver wrote: On 05/08/2014 03:11 PM, Vincent de Phily wrote: On Thursday 08 May 2014 06:30:39 Adrian Klaver wrote: On 05/08/2014 04:09 AM, Vincent de Phily wrote: Before you grow suspicious of that con

Re: [GENERAL] Oracle to PostgreSQL replication

2014-05-09 Thread Albe Laurenz
Sameer Kumar wrote: > I guess I will be exploring more on oracle foreign data wrapper. > > Has anyone tried using oracle_fdw with Oracle RAC? I am wondering how would > it handle failovers. I have not tried it, but it should work as follows: - You'll have to use a connect string that is correct

Re: [GENERAL] Receiving many more rows than expected

2014-05-09 Thread Vincent de Phily
On Friday 09 May 2014 07:01:32 Tom Lane wrote: > Vincent de Phily writes: > > In case it changes anything, this is the uncut (but still anonimized) > > > > function: > > query = """UPDATE foo SET processing = 't' WHERE id IN > > > >(SELECT id FROM foo WHERE processing = 'f' O

Re: [GENERAL] Receiving many more rows than expected

2014-05-09 Thread Tom Lane
Vincent de Phily writes: > In case it changes anything, this is the uncut (but still anonimized) > function: > query = """UPDATE foo SET processing = 't' WHERE id IN > >

Re: [GENERAL] Receiving many more rows than expected

2014-05-09 Thread Vincent de Phily
On Thursday 08 May 2014 16:56:25 Adrian Klaver wrote: > On 05/08/2014 03:11 PM, Vincent de Phily wrote: > > On Thursday 08 May 2014 06:30:39 Adrian Klaver wrote: > >> On 05/08/2014 04:09 AM, Vincent de Phily wrote: > > The histogram shows a large amount of small values, progressively becoming > > r

Re: [GENERAL] Oracle to PostgreSQL replication

2014-05-09 Thread Thomas Kellerer
Rajni Baliyan, 09.05.2014 09:46: > I downloaded symmetricDS but I did not found any installer > (symmetric-pro-x.x.x.jar) > Can any one please help me in this This might help: http://www.symmetricds.org/doc/3.5/html/tutorial.html#tutorial-install -- Sent via pgsql-general mailing list (pg

Re: [GENERAL] Receiving many more rows than expected

2014-05-09 Thread Vincent de Phily
On Thursday 08 May 2014 16:05:59 Sim Zacks wrote: > On 05/08/2014 02:09 PM, Vincent de Phily wrote: > The problem is that sometimes (once every few days at about 2-300K queries > per day) I get many more rows than the max 5000 I asked for (I've seen up > to 25k). And I'm getting timeouts and other

Re: [GENERAL] Oracle to PostgreSQL replication

2014-05-09 Thread Rajni Baliyan
I downloaded symmetricDS but I did not found any installer (symmetric-pro-x.x.x.jar) Can any one please help me in this Thanks Best Regards, *Rajni Baliyan | Database - Consultant* *ASHNIK PTE. LTD.*101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533 M:+65 87294147 T: +65 6438 3504 | ww