Re: [HACKERS] [WIP]Vertical Clustered Index (columnar store extension)

On 30.12.2016 06:55, Haribabu Kommi wrote: Hi All, Fujitsu was interested in developing a columnar storage extension with minimal changes the server backend. We in PostgresPRO are also very interested in developing vertical storage (VS) for Postgres. And after considering many alternative

Re: [HACKERS] Index corruption with CREATE INDEX CONCURRENTLY

On Thu, Feb 2, 2017 at 10:14 PM, Alvaro Herrera wrote: > > > I'm going to study the bug a bit more, and put in some patch before the > upcoming minor tag on Monday. > > Looking at the history and some past discussions, it seems Tomas reported somewhat similar problem and Andres proposed a patch h

[HACKERS] Documentation improvements for partitioning

Here are some patches to improve the documentation about partitioned tables: 0001: Adds some details about partition_bound_spec to the CREATE TABLE page, especially: - a note about inclusivity of range partition bounds, - a note about the UNBOUNDED literal in case of range partitioning, - a no

[HACKERS] Postgres_fdw behaves oddly

Hello, I have tested some scenarios of inserting data into two foreign tables using postgres_fdw. All the test cases works fine except Test 5. In Test 5, I am expecting error as both the rows violates the constraint. But at the COMMIT time transaction does not give any error and it takes loc

Re: [HACKERS] Logical Replication and Character encoding

Hello, At Fri, 3 Feb 2017 13:47:54 +0800, Craig Ringer wrote in > On 3 Feb. 2017 15:47, "Kyotaro HORIGUCHI" > wrote: > > Hello, > > At Fri, 3 Feb 2017 09:16:47 +0800, Craig Ringer > wrote in > > > On 2 February 2017 at 11:45, Euler Taveira wrote: > > > > > I don't think storage without co

Re: [HACKERS] IF (NOT) EXISTS in psql-completion

Hello. This is the new version of this patch. - Rebased to the current master (555494d) PUBLICATION/SUBSCRIPTION stuff conflicted. - Fix a bug of CREATE INDEX(0012-Simplify-completion-for-CREATE-INDEX.patch). CREATE INDEX ON no longer gets a suggestion of "ON". - Added logging feature (0018

Re: [HACKERS] Non-deterministic behavior with floating point in parallel mode

On Fri, Feb 3, 2017 at 3:49 AM, Tom Lane wrote: > Ruben Buchatskiy writes: >> We have found that in parallel mode result of queries is non-deterministic >> when the types of the attributes in table are double precision >> (floating-point). > > Yeah ... > >> That is because floating-point addition

<    1   2