Re: [GENERAL] Weird effects using BLOBs from libpq

2000-10-23 Thread Joerg Hessdoerfer
At 17:52 22.10.00 -0400, you wrote: [...] > > First effect I have noticed is that when I write more than a certain > > amount of data at once using lo_write(), my application hangs > > indefinitely (10K work perfect, 100K not). Is there a well-known > > limit? On what does it depend? Or is it an

Re: [GENERAL] Weird effects using BLOBs from libpq

2000-10-23 Thread Joerg Hessdoerfer
Hi! Just as a follow-up to my last posting - disregard my complaints ;-) I've just checked under Linux - works fine. Then i went back to my WIN NT box, and double checked libraries. See what i found: i actually used a WIN32 build of the libpq - not the cygwin build. When using that, everything i

[GENERAL] Universal B-trees...

2001-01-15 Thread Joerg Hessdoerfer
Hi! I just came across an interesting article in a german PC-Mag, covering use of universal B-trees for indexing multi-index databases. Looks VERY promising, indeed. I dunno if that could be implemented in postgreSQL, or is of any interest at all, but here's an URL for anyone ineterested: http

Re: [GENERAL] Not using index

2001-02-07 Thread Joerg Hessdoerfer
At 14:47 07.02.01 +, you wrote: >Hi, >I have a table with about 8million tuples in it. I need to do a search >on two of the table's columns, so I've created a couple of indices, one >for each column. >Then I've run VACUUM ANALYZE. The query planner still wants to do a >sequential scan on the d