On Fri, Aug 30, 2013 at 2:10 AM, 高健 wrote:
>
>
> postgres=# insert into test01 values(generate_series(1,2457600),repeat(
> chr(int4(random()*26)+65),1024));
The construct "values (srf1,srf2)" will generate its entire result set
in memory up front, it will not "stream" its results to the insert
st
Kevin Grittner wrote:
> - We don't distinguish between heap relation locks which need to
> prohibit inserts (those caused by a table scan) and heap relation
> locks which don't conflict with inserts (those caused by promotion
> from finer granularity). We would reduce false positives if we
> d
Gianni Ceccarelli wrote:
> At work we have a program that seems to be stressing the SSI
> implementation, and I thought that it could provide useful
> insights to better tune it. In particular, there are a few parts
> that are described as "chosen entirely arbitrarily (and without
> benchmarking)
