reseting files - Search results

file. Values set in the command line options override values from the configuration file. Usage

sets the file names of the created log files. The value is treated as a strftime

reset waits profile by calling the pg_wait_sampling_reset_profile() function. If you connect

Sets the location of the server's Kerberos key file. The default is FILE:/usr/local/pgsql/etc/krb5.keytab

set in the postgresql.conf file or on the server command line. If you turn

file. For daemonization ( -d ), either this or syslog has to be set. The log file

profile WHERE event IS NOT NULL GROUP BY event_type, event; GET DIAGNOSTICS result = ROW_COUNT; PERFORM pg_wait_sampling_reset

filed width in a column. Field width for data types such as integer or char(3) is obviously fixed, but when it comes to data types with no set width

set by LIMIT, for example), the operation will not be executed fully. The two SEQSCAN leafs are table scans. Upon request from the parent node, a leaf node reads the next row from the table

SET enable_bitmapscan = off; EXPLAIN SELECT * FROM bookings WHERE book_date < '2016-08-23 12:00:00+03'; QUERY PLAN

file. Sequential scan is the most cost-effective way of scanning a whole table or a significant portion of it. In other words, sequential scan is efficient when selectivity is low. At higher selectivity, when

set the new number in autovacuum_max_workers and reload the configuration files, as long

set up 'Admin' user password: ssh azureuser@myvm-ent-xx-dnsname.northeurope.cloudapp.azure.com sudo su - postgres source .pgsql_profile psql --dbname

set up the 'Admin' user password: ssh azureuser@myvm-std-xx-dnsname.northeurope.cloudapp.azure.com sudo su - postgres source .pgsql_profile psql

set up 'Admin' user password: ssh yc-user@$VM_IP_ADDRESS sudo su - postgres source .pgsql_profile

set up 'Admin' user password: gcloud compute ssh SYSTEM@$INSTANCE sudo su - postgres source .pgsql_profile

set up 'Admin' user password: ssh root@$IpAddress sudo su - postgres source .pgsql_profile psql

set up 'Admin' user password: gcloud compute ssh SYSTEM@$INSTANCE sudo su - postgres source .pgsql_profile

files required to restore the cluster to a consistent state at the time the backup was taken. Even if continuous archiving is not set up, the required