[PERFORM] Certain query eating up all free memory (out of memory error)

2010-05-27 Thread Łukasz Dejneka
Hi group, I could really use your help with this one. I don't have all the details right now (I can provide more descriptions tomorrow and logs if needed), but maybe this will be enough: I have written a PG (8.3.8) module, which uses Flex Lexical Analyser. It takes text from database field and fi

Re: [PERFORM] Certain query eating up all free memory (out of memory error)

2010-05-24 Thread Łukasz Dejneka
EXPLAIN ANALYSE on smaller query: "Seq Scan on teksty (cost=0.00..1353.50 rows=1 width=695) (actual time=0.220..12.354 rows=368 loops=1)" " Filter: (id = 1)" "Total runtime: 12.488 ms" Memory config: # - Memory - shared_buffers = 24MB temp_buffers = 8MB max_prepared_transactions = 5 work_mem

[PERFORM] Certain query eating up all free memory (out of memory error)

2010-05-24 Thread Łukasz Dejneka
Hi group, I could really use your help with this one. I don't have all the details right now (I can provide more descriptions tomorrow and logs if needed), but maybe this will be enough: I have written a PG (8.3.8) module, which uses Flex Lexical Analyser. It takes text from database field and fi