Re: [PERFORM]

Thanks we'll give that a try. On Fri, Jun 6, 2014 at 7:38 PM, Tom Lane wrote: > Scott Marlowe writes: >> Well it's me again, with another performance regression. We have this query: >> SELECT * >> FROM users u >> WHERE (u.user_group_id IN >> (SELECT ug.id >> FROM user_groups ug, pro_pa

Re: [PERFORM]

Scott Marlowe writes: > Well it's me again, with another performance regression. We have this query: > SELECT * > FROM users u > WHERE (u.user_group_id IN > (SELECT ug.id > FROM user_groups ug, pro_partners p > WHERE ug.pro_partner_id = p.id > AND p.tree_sortkey BETWEEN > E'0

[PERFORM]

Well it's me again, with another performance regression. We have this query: SELECT * FROM users u WHERE (u.user_group_id IN (SELECT ug.id FROM user_groups ug, pro_partners p WHERE ug.pro_partner_id = p.id AND p.tree_sortkey BETWEEN E'000101010100010100011

Re: [PERFORM] CPU load spikes when CentOS tries to reclaim 'cached' memory

On Thu, Jun 5, 2014 at 6:57 PM, Vincent Lasmarias wrote: > Thanks for the informative responses and suggestions. My responses below: > > * Sorry for the double post. I posted the original message using my gmail > account and got a "is not a member of any of the restrict_post groups" > response and

[PERFORM] Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0

Yes I can create a simpler version that exhibits the problem: postgres_bug_simpler.sql This only now involves one smaller table 60K rows, and a linked table with 20M rows. I tried with 6K and 1M but could not get p