Good day,
See the sequence below, Postgresql 9.6.5 on Debian using the postgresql
repository.
Question: Is this expected behaviour?
postgres@tracsdbhvt01:~$ cat test-serial.sql
create database test;
\c test
create table test_serial ( teststring varchar(5));
alter table test_serial add colum
> On 25 Sep 2017, at 09:51 , hvjunk wrote:
>
> Good day,
>
> See the sequence below, Postgresql 9.6.5 on Debian using the postgresql
> repository.
>
> Question: Is this expected behaviour?
I guess it might be, but the “bug” is that the excessive/unused sequence isn’t
removed:
test=# \d te
Thanks again - for some reason I thought that each page should be fsynced
separately...
I am running ZFS and going to try following config on 32gb server:
shared_buffers = 512mb (previously was 6gb)
max_wal_size = 8gb
zfs_arc_max = 24gb
i.e. run with minimal shared buffers and do all the caching
On 09/25/2017 11:10 AM, Vladimir Mihailenco wrote:
> Thanks again - for some reason I thought that each page should be
> fsynced separately...
>
> I am running ZFS and going to try following config on 32gb server:
>
> shared_buffers = 512mb (previously was 6gb)
> max_wal_size = 8gb
> zfs_arc_ma
