From: | Michael Paquier <michael(at)paquier(dot)xyz> |
---|---|
To: | Dmitry Dolgov <9erthalion6(at)gmail(dot)com> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: LLVM jit and matview |
Date: | 2018-07-10 00:19:58 |
Message-ID: | 20180710001958.GD1661@paquier.xyz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
On Mon, Jul 09, 2018 at 04:04:11PM +0200, Dmitry Dolgov wrote:
> # matview.sql
> ...
> =# REFRESH MATERIALIZED VIEW CONCURRENTLY mvtest_tm;
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed.
Problem reproduced here with exactly the same stack. Here is a simple
SQL sequence:
create table aa (a int);
create materialized view aam as select * from aa;
create unique index aami on aam(a);
insert into aa values (generate_series(1,100000));
refresh materialized view CONCURRENTLY aam;
I have added an open item.
--
Michael
From | Date | Subject | |
---|---|---|---|
Next Message | Noah Misch | 2018-07-10 01:43:08 | Extension relocation vs. schema qualification |
Previous Message | Andrew Dunstan | 2018-07-10 00:06:00 | Re: cannot restore schema with is not distinct from on hstore since PG 9.6.8 |
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2018-07-10 00:52:16 | Re: Usage of epoch in txid_current |
Previous Message | Andres Freund | 2018-07-10 00:08:34 | Re: Usage of epoch in txid_current |