Re: [HACKERS] Bogus ANALYZE results for an otherwise-unique column with many nulls

2016-08-05 Thread Andrew Gierth
> "Tom" == Tom Lane writes: Tom> What I did in the patch is to scale the formerly fixed "-1.0" Tom> stadistinct estimate to discount the fraction of nulls we found. This seems quite dubious to me. stadistinct representing only the non-null values seems to me to be substantially more useful

Re: [HACKERS] Oddity in EXPLAIN for foreign/custom join pushdown plans

2016-08-05 Thread Etsuro Fujita
On 2016/08/02 21:35, Etsuro Fujita wrote: I removed the Relations line. Here is an updated version of the patch. I revised code and comments a bit. Attached is an updated version of the patch. Best regards, Etsuro Fujita explain-for-foreign-join-pushdown-v2.patch Description: binary/oct

Re: [HACKERS] [sqlsmith] FailedAssertion("!(XLogCtl->Insert.exclusiveBackup)", File: "xlog.c", Line: 10200)

2016-08-05 Thread Kyotaro HORIGUCHI
Hello, While the exact cause of the situation is not known yet but we have apparently forgot that pg_stop_backup can be called simultaneously with pg_start_backup. It seems anyway to me that pg_stop_backup should be called before the end of pg_start_backup from their definition and what they do. A

[HACKERS] Refactoring of heapam code.

2016-08-05 Thread Anastasia Lubennikova
Working on page compression and some other issues related to access methods, I found out that the code related to heap looks too complicated. Much more complicated, than it should be. Since I anyway got into this area, I want to suggest a set of improvements. There is a number of problems I see i

Re: [HACKERS] regression test for extended query protocol

2016-08-05 Thread Michael Paquier
On Fri, Aug 5, 2016 at 12:21 AM, Alvaro Herrera wrote: > If somebody had some spare time to devote to this, I would suggest to > implement something in core that can be used to specify a list of > commands to run, and a list of files-to-be-saved-in-bf-log emitted by > each command. We could have

<    1   2