Re: GIN Index for low cardinality

>>Does it mean that GIN is a very good choice for low cardinality columns.   >Not necessary. There is other index which also don’t keep column value in an >every leaf. Hash, for instance.  Well I asked about GIN's usefulness for low cardinality. Good to know that Hash can also be considered.

Re: Compile and build portable postgresql for mac

On Wed, Oct 24, 2018 at 7:22 PM Pratik Parikh wrote: > How to compile and build portable postgresql for mac. Can someone > point me how the builds are done for general distribution. A script would > be appreciated if anyone has it. > I'm not sure what you mean by "portable"? I'm going to

Re: Compile and build portable postgresql for mac

Thanks, I'll check them out. But what I am trying to produce is a zip distribution fo Mac is x similar to the one available on postgresql download site. Homebrew works but it ties the libpg to prefix if the path where libs are generated. I am trying to do some unit testing across more then one

Re: Should pg 11 use a lot more memory building an spgist index?

It looks like it got past creating the exclude constraint based on the ordering of commands in the dump file. However creating a more normal spgist index is taking a very long time with a lot of disk wait time. CPU usage seems pretty low for the amount of time it has been working on building

Re: Should pg 11 use a lot more memory building an spgist index?

On Wed, Oct 24, 2018 at 10:21:11 +0100, Tom Lane wrote: Bruno Wolff III writes: If I have a substantial database dump file to provide for reproducing this do you prefer it on a web server somewhere? I expect that mailing very large attachments to the lists is a bad idea. No, don't do that.

Re: rw_redis_fdw: SQL Errors when statement is within a function

## GPT (gptmailingli...@gmail.com): > So, this kind of switch after a few goes is a normal behavior or > something unexpected which will change in future? It's expected, and even documented (when you look at the user-level interface):

Re: Postgresql issue: FATAL: dsa_allocate could not find 7 free pages

On Fri, Oct 26, 2018 at 2:21 AM Alexandre Assouad wrote: > FATAL: dsa_allocate could not find 7 free pages > Some users have faced this issue which seems to be a bug in postgresql query > planner which should be solved : >

Re: Compile and build portable postgresql for mac

> 25 окт. 2018 г., в 3:21, Pratik Parikh написал(а): > > Hi all, > > How to compile and build portable postgresql for mac. Can someone point > me how the builds are done for general distribution. A script would be > appreciated if anyone has it. > > Regards, > Pratik You can try

Re: Compile and build portable postgresql for mac

Your best bet in mac is to use docker. On Thursday, October 25, 2018 Pratik Parikh wrote: Thanks, I'll check them out.  But what I am trying to produce is a zip distribution fo Mac is x similar to the one available on postgresql download site. Homebrew works but it ties the libpg to prefix

Re: rw_redis_fdw: SQL Errors when statement is within a function

So, this kind of switch after a few goes is a normal behavior or something unexpected which will change in future? I am asking in order to have my mind on incidents with similar behavior. Tia On 10/25/18, Andres Freund wrote: > Hi, > > On 2018-10-25 11:43:39 +0200, GPT wrote: >> I have faced

rw_redis_fdw: SQL Errors when statement is within a function

Hi, I have faced an incident which, according to the developer, "The problem seems to be that pgsql switches from a CONST sub-expression into a FUNCEXPR after a few goes, ..." Please have a look at the following two links which describe the problem: