Re: [GENERAL] json indexing and data types

On Wed, Dec 2, 2015 at 11:48 AM, Kaare Rasmussen wrote: > Hi > > As json essentially only has three basic data types, string, int, and > boolean, I wonder how much of this - to index, search, and sort on > unstructured data - is possible. I guess part of the answer would be >

[GENERAL] Memory Leak executing small queries without closing the connection

Hello, We are running PostgreSQL 9.4.5 on FreeBSD 10.1 and have multiple worker processes connected via persistent connections to PostgreSQL, they perform just simple queries with SELECT on primary keys and simple INSERTS/UPDATES. Normally nearly all the workers are idle but they still

Re: [GENERAL] connections not getting closed on a replica

Assuming you have at least 16GB of memory. These numbers on a good hardware server is not a real problem. On a bad server motherboard. Might as well use a standard PC. With 32GB I have tested 10 times more connections. Not to postgresql. I would investigate everything from bottom up. Also

[GENERAL] postgresql 9.3 failover time

*Hi,* *I have postgresql 9.3 setup with 2 nodes (active/standby with streaming replication & continuos archiving).* *I have created 2 failover & failback script in order to perform a switchover between the DB servers:* *1. failover - create a trigger file in order to promote the new primary.* *2.