Re: [HACKERS] index-only count(*) for indexes supporting bitmap scans

I've pushed the executor part of this, but mostly not the planner part, because I didn't think the latter was anywhere near ready for prime time: the regression test changes it was causing were entirely bogus. Hi Tom, Thanks for the commit and the explanation. I'll try to address your

[HACKERS] ginInsertCleanup called from vacuum could still miss tuples to be deleted

Hi, Commit e2c79e14 prevented multiple cleanup process for pending list in GIN index. But I think that there is still possibility that vacuum could miss tuples to be deleted if someone else is cleaning up the pending list. In ginInsertCleanup(), we lock the GIN meta page by LockPage and could

Re: [HACKERS] Partition-wise aggregation/grouping

On 11.11.2017 23:29, Konstantin Knizhnik wrote: On 10/27/2017 02:01 PM, Jeevan Chalke wrote: Hi, Attached new patch-set here. Changes include: 1. Added separate patch for costing Append node as discussed up-front in the patch-set. 2. Since we now cost Append node, we don't need

Re: [HACKERS] How to implement a SP-GiST index as a extension module?

Hi! On Mon, Nov 13, 2017 at 6:47 AM, Connor Wolf wrote: > Ok, I've managed to get my custom index working. > Good! It's all on github here: https://github.com/fake-name/pg-spgist_hamming, if > anyone else needs a fuzzy-image searching system > that can

Re: [HACKERS] [Patch] Log SSL certificate verification errors

Graham Leggett wrote: > Currently neither the server side nor the client side SSL certificate verify > callback does anything, leading to potential hair-tearing-out moments. > > The following patch to master implements logging of all certificate > verification failures, as well as (crucially)

Re: [HACKERS] 10beta1 sequence regression failure on sparc64

Christoph, what beta2 change was it that fixed that problem? I'm having exactly the same regression test failure in version 10.1 (not beta) running on Solaris 9 Compiler used: GCC 4.6.4 CFLAGS: -O2 -m64 On 13/07/2017 20:05, Christoph Berg wrote: Re: To Andres Freund 2017-05-24

Re: [HACKERS] Fix bloom WAL tap test

Hi! On Fri, Nov 10, 2017 at 9:12 PM, Tom Lane wrote: > I wrote: > > Is there anything we can do to cut the runtime of the TAP test to > > the point where running it by default wouldn't be so painful? > > As an experiment, I tried simply cutting the size of the test table

Re: [HACKERS] proposal: schema variables

Hello, Pavel. You wrote: PS> Hi, PS> I propose a  new database object - a variable. The variable is PS> persistent object, that holds unshared session based not PS> transactional in memory value of any type. Like variables in any PS> other languages. The persistence is required for possibility

Re: [HACKERS] path toward faster partition pruning

Horiguchi-san, Thanks for taking a look. Replying to all your emails here. On 2017/11/10 12:30, Kyotaro HORIGUCHI wrote: > In 0002, bms_add_range has a bit naive-looking loop > > + while (wordnum <= uwordnum) > + { > + bitmapword mask = (bitmapword) ~0; > + > +

Re: [HACKERS] Jsonb transform for pl/python

On Thu, 09 Nov 2017 12:26:46 + Aleksander Alekseev wrote: > The following review has been posted through the commitfest > application: make installcheck-world: tested, failed > Implements feature: tested, passed > Spec compliant: tested, passed >

Re: [HACKERS] UPDATE of partition key

On 10 November 2017 at 16:42, Amit Khandekar wrote: [ update-partition-key_v23.patch ] Hi Amit, Thanks for working on this. I'm looking forward to seeing this go in. So... I've signed myself up to review the patch, and I've just had a look at it, (after first reading

Re: [HACKERS] proposal: schema variables

Hi 2017-11-13 13:15 GMT+01:00 Pavel Golub : > Hello, Pavel. > > You wrote: > > PS> Hi, > > PS> I propose a new database object - a variable. The variable is > PS> persistent object, that holds unshared session based not > PS> transactional in memory value of any type. Like

Re: [HACKERS] Parallel Hash take II

Hi Andres and Peter, Please see below for inline responses to your feedback. New patch attached. On Wed, Nov 8, 2017 at 10:01 AM, Andres Freund wrote: > +set min_parallel_table_scan_size = 0; > +set parallel_setup_cost = 0; > +-- Make a simple relation with well distributed

[HACKERS] Migration to pglister - Before

Greetings, We will be migrating these lists to pglister in the next few minutes. This final email on the old list system is intended to let you know that future emails will have different headers and you will need to adjust your filters. The changes which we expect to be most significant to