Re: [PERFORM] many to many performance

2008-11-27 Thread Chavdar Kopoev
it 2) as q) This query should never be run - too slow even with limit 20k of input ids. So .. final best result is more than 1 second (on fast machine) for test dataset 5 times less than needed. So I am far away from achieving good results. I have to ask again if anyone faced similar situa

[PERFORM] many to many performance

2008-11-26 Thread Chavdar Kopoev
I want to ask, have anyone faced similar situation, and is there any way to achive closer to optimal performance using postgresql functionality and extensibility? Regards, Chavdar Kopoev -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to you

[PERFORM] many to many performance

2008-11-26 Thread Chavdar Kopoev
I want to ask, have anyone faced similar situation, and is there any way to achive closer to optimal performance using postgresql functionality and extensibility? Regards, Chavdar Kopoev -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to you