From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Garick Hamlin <ghamlin(at)isc(dot)upenn(dot)edu> |
Cc: | PG Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: 9.1beta2 / UNLOGGED + CHECK + INHERITS |
Date: | 2011-06-17 17:37:52 |
Message-ID: | BANLkTimZojmknKEVEnZhJBHxXSg-7uvaQA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Fri, Jun 17, 2011 at 1:01 PM, Garick Hamlin <ghamlin(at)isc(dot)upenn(dot)edu> wrote:
> I wanted to see how much faster unlogged tables might be for an
> app I have, so as a quick test I did:
>
> s/CREATE TABLE/CREATE UNLOGGED TABLE/ to get some numbers.
> Which lead to a crash.
>
> Here is a trimmed down test case:
> $ cat > unlog-test.sql
> CREATE UNLOGGED TABLE leases (
> mac macaddr NOT NULL,
> ip inet NOT NULL,
> start_ts timestamp with time zone NOT NULL,
> end_ts timestamp with time zone NOT NULL,
> id bigint NOT NULL,
> truncated integer,
> router_ip inet,
> CONSTRAINT leases_check CHECK ((start_ts < end_ts))
> );
> CREATE UNLOGGED TABLE closed_leases (
> )
> INHERITS (leases);
> CREATE UNLOGGED TABLE open_leases (
> )
> INHERITS (leases);
> ^D
>
> $ psql91 -U postgres postgres -c '\i unlog-test.sql'
> CREATE TABLE
> psql91:unlog-test.sql:13: server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> psql91:unlog-test.sql:13: connection to server was lost
Fixed, thanks for the report!
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-06-17 18:15:13 | Re: [HACKERS] Issues with generate_series using integer boundaries |
Previous Message | Tom Lane | 2011-06-17 17:22:40 | Re: ALTER TABLE lock strength reduction patch is unsafe |