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 127.0
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, but
Thanks for pointing out those links. I am trying to figure out how they can
help me.
One more thing, I can't understand the postgresql.log duration vs. a "EXPLAIN
ANALYZE" in the query:
Postgresql.log gives:
duration: 628.000 ms parse (...)
duration: 0.000 ms bind (...)
duration: 378.000 ms e
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:
> N
No, I have not checked it.
How can I monitor it on Windows? Do you know a tool that can help me?
Thanks!
-Message d'origine-
De : Robert Zenz [mailto:robert.z...@sibvisions.com]
Envoyé : jeudi 11 janvier 2018 10:01
À : pgsql-performance@lists.postgresql.org
Objet : Re: Slow queries after
Have you verified that this is isn't caused by cold filesystem caches?
On 11.01.2018 09:19, POUSSEL, Guillaume wrote:
> Hello,
>
>
>
> I’m running PostgreSQL 9.3 on Windows 7 and I’m having a performance
> issue at startup. I have installed PostgreSQL as a service through Windows
> installer.
Hello,
I’m running PostgreSQL 9.3 on Windows 7 and I’m having a performance
issue at startup. I have installed PostgreSQL as a service through Windows
installer.
The database size is 3 Go, with 120 tables.
Every time I try to run queries right after Windows startup, it takes a
huge amount
