New answers tagged

0

You're describing one or two intensive queries. From experience Postgres will use multiple core's but each query is bound to a single core / thread (related I/O can be on other cores


0

I tried creating a "dbadmin" user and I couldn't connect to the instance. it seems that this exact name have some issues. try to create another user name and export accordingly.


3

You are providing the parameters in the wrong order. From man fail2ban-regex: fail2ban-regex [OPTIONS] <LOG> <REGEX> [IGNOREREGEX] You must provide first the log file and then the configuration file, you are doing it the other way around.


1

The home directory of the user xzy is not readable by user postgres, but you start the psql command from there. As a result, you get *permission deny *. Change the directory to some other place before running the sudo: cd / sudo -u postgres psql


1

Please do this from root account. So first become root user: $ sudo -i # and then: # su - postgres


0

The short answer to this question unfortunately is that it is not possible to make it permanent update. However, I found a work-around and I hope this could be useful for anyone who develop from China. Get a server running outside China. (For my case I used Vultr. It is as cheap as $5 / month.) You can use whatever convenient for you. Install gcloud in that ...


1

PostgreSQL has a built-in autovavuum that should be enabled and configured to match your needs. Typically you adjust *autovacuum_vacuum_threshold * and autovacuum_analyze_threshold to kick off desired behavior based on the number of changed tuples. See https://www.postgresql.org/docs/current/routine-vacuuming.html#AUTOVACUUM


1

It sounds like you have autovacuum disabled, which if it were enabled would analyze all of your tables periodically to update their statistics for the query planner. The simplest solution is to re-enable autovacuum. Check your postgresql.conf file for the autovacuum setting.


-1

Yes. Its Cause of permission issues to postgresql folders on your system. try with 0777


0

Hardly an answer to my question, but I will document what I have found: simply using \dt+ *.* to generate psql description of the entire database https://www.schemacrawler.com/output.html generates diff friendly schema in plain text, HTML and JSON. http://schemaspy.org/ - not what I was looking for, but discovered as a great way to document the current ...


Top 50 recent answers are included