Re: [PERFORM] Performance under contention

2010-11-24 Thread Vitalii Tymchyshyn
24.11.10 02:11, Craig Ringer написав(ла): On 11/22/2010 11:38 PM, Ivan Voras wrote: On 11/22/10 16:26, Kevin Grittner wrote: Ivan Vorasivo...@freebsd.org wrote: On 11/22/10 02:47, Kevin Grittner wrote: Ivan Voras wrote: After 16 clients (which is still good since there are only 12 real

Re: [PERFORM] Performance under contention

2010-11-24 Thread Kevin Grittner
Vitalii Tymchyshyn tiv...@gmail.com wrote: the simplest option that will make most people happy would be to have a limit (waitable semaphore) on backends actively executing the query. That's very similar to the admission control policy I proposed, except that I suggested a limit on the

[PERFORM] Optimizing query

2010-11-24 Thread pasman pasmański
Hello. I have a query which works a bit slow. It's runned on desktop computer: AMD Athlon X2 2GHz , Win Xp sp2, 1GB ram. Postgres 8.4.5 with some changes in config: shared_buffers = 200MB # min 128kB # (change requires restart) temp_buffers = 8MB

[PERFORM] problem with from_collapse_limit and joined views

2010-11-24 Thread Markus Schulz
hello, i have a big performance problem with some views which would joined (from the third party tool crystal reports) to print a document. view1: SELECT ... FROM personen.kunde kunde, personen.natuerliche_person person, viewakteur akteur, personen.anschrift adresse,