Re: Slow queries after Windows startup

2018-01-11 Thread Robert Zenz
I have no idea to be honest, I haven't done any Windows administration in a long time. The best I could find is this: * https://docs.microsoft.com/en-us/sysinternals/downloads/rammap * https://technet.microsoft.com/en-us/library/cc938589.aspx On 11.01.2018 10:06, POUSSEL, Guillaume wrote: >

Disjunctions and sequential scans

2018-01-11 Thread Ronuk Raval
Hi there, This is likely me not understanding something, but I have a query that I would expect to be fast but PG insists on using a sequential scan. I've attached a minimized test case but I'll walk through the steps as well. I'm running PostgreSQL 10.1 using the standard ArchLinux packages,

PGadmin error while connecting with database.

2018-01-11 Thread Dinesh Chandra 12108
Dear Expert, While connecting PostgreSQL 9.3 with PGAdmin client I am getting the below error. [cid:image001.png@01D38B8F.6F382110] However I am able to connect the database using psql thourgh Putty. Entry in pg_hba.conf # IPv4 local connections: hostall all