On 01/08/14 09:38, Alvaro Herrera wrote:
Matt Clarkson wrote:
The LWLOCK_STATS below suggest that ProcArrayLock might be the main
source of locking that's causing throughput to take a dive as the client
count increases beyond the core count.
Any thoughts or comments on these results are welc
hi ,everybody
why does the planer estimate 200 rows when i use order by and group by .
evn:postgresql 8.4 and 9.3
table:
CREATE TABLE a
(
id serial NOT NULL,
name character varying(20),
modifytime timestamp without time zone,
CONSTRAINT a_pk PRIMARY KEY (id)
)
SQL:
explain analyze
selec
