Re: [PERFORM] Linux: more cores = less concurrency.

Hi, I think that a NUMA architecture machine can solve the problem A + Le 11/04/2011 15:04, Glyn Astill a écrit : Hi Guys, I'm just doing some tests on a new server running one of our heavy select functions (the select part of a plpgsql function to allocate seats) concurrently. We do u

Re: [PERFORM] Inoptimal query plan for max() and multicolumn index

Le 20/06/2011 18:08, Vladimir Kulev a écrit : Yes, exactly :) SQL Server does it but PG does not. Expect this for the future So try to rewrite the query like this : select max(timestamp) from sms where number = '5502712' UNIUON ALL, select max(timestamp) from sms where number = '5802693'