New answers tagged

1

An answer to this question was provided on the AWS Developer Forums thread to which it was originally posted. Summary RDS PostgreSQL (as of the versions available in April 2018) doesn't always recover after restart; however, if the RDS instance does not shutdown within an unspecified timeout, RDS will force terminate the instance, requiring PostgreSQL to ...


0

Use the site below for choose your character, then use example: http://pgdocptbr.sourceforge.net/pg82/multibyte.html#CHARSET-TABLE postgres=# CREATE DATABASE database_name WITH TABLESPACE tablespace_name TEMPLATE = template0 OWNER = database_user ENCODING 'WIN1252' LC_CTYPE = 'Portuguese_Brazil.1252' LC_COLLATE = '...


0

I had the same problem, but because a very strange reason... In my opinion... See these outputs... root@srv_nm:/tmp# chown -R postgres "/some/path/data" root@srv_nm:/tmp# chown -R :postgres "/some/path/data" root@srv_nm:/tmp# chmod -R 700 "/some/path/data" root@srv_nm:/tmp# ls -al "/some/path/data" total 40 drws--S--- ...


0

Statistic for the query planner: n_distinct I misread at first. You do run ANALYZE on the temporary table. You commented: The temp table is immutable: it's created once, analyzed and never changes. It exists because we had a problem with plain query being inefficient, so we extracted the rows we're interested in to a temp table to have statistics about it. ...


Top 50 recent answers are included