Re: [PERFORM] bad performance

Gabliver Faluker writes: > It runs for ~5 seconds . I'm a little skeptical that a 12-way join producing 340K rows and executing in 5 seconds should be considered "bad performance". It looks like it'd help some if you increased work_mem enough to let both sorts happen

[PERFORM] bad performance

Hey All, I am not a PG expert. I like PG but i am puzzled as to what I shoud do . I have a 4 core 5 GIG vm running a 500M db (it should fit to ram easly) and I face slow queries. here is a view that I have : SELECT o.id, cc.name AS "from", o.phone, c.name AS "to",