2015-05-28 1:41 GMT+08:00 David G. Johnston :
> On Tue, May 26, 2015 at 7:03 PM, digoal zhou
> wrote:
>
>> When we create table, some column use foreign key references.
>> Now PostgreSQL don't create index for the FK, and there is no problem.
>> But when some bod
When we create table, some column use foreign key references.
Now PostgreSQL don't create index for the FK, and there is no problem.
But when some body need the index to speed up the query within these APP,
they need to add the index manual one-by-one when has many tables.
If we can add syntax for
PostgreSQL (<=9.4) trend to smooth buffer write smooth in a
checkpoint_completion_target (checkpoint_timeout or checkpoint_segments),
but when we use synchronous_commit=off, there is a little problem for
the checkpoint_segments
target, because xlog write fast(for full page write which the first