vacuum and autovacuum - is it good to configure the threshold at TABLE LEVEL?

Hi, Please suggest me on the following, 1. Is it better to configure autovacuum threshold at table level? 2. Is there any discussions in this forum which I can refer for understanding vacuum/autovacuum? Thanks in advance. Rajan. - -- Thanks, Rajan. -- Sent from: http://www.postgresql

Re: vacuum and autovacuum - is it good to configure the threshold at TABLE LEVEL?

= 100);* at table level. - -- Thanks, Rajan. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html

Re: vacuum and autovacuum - is it good to configure the threshold at TABLE LEVEL?

thanks for the reply, amul. - -- Thanks, Rajan. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html

where clause not working through psql command line client

postgres@Server2[DEV][backup] $ psql -c 'select * from pg_class where relname = pg_toast_22345' ERROR: column "pg_toast_16387" does not exist LINE 1: select * from pg_class where relname = pg_toast_22345 ----- -- Thanks, Rajan. -- Sent from: http://www.postgresql-ar

Re: where clause not working through psql command line client

Thanks a lot, Amul. - -- Thanks, Rajan. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html

Able to do ALTER DEFAULT PRIVILEGES from a user who is not the owner

ERT ON TABLE additional.chess TO student; ERROR: permission denied for relation chess learning=> - -- Thanks, Rajan. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html

Re: Able to do ALTER DEFAULT PRIVILEGES from a user who is not the owner

THanks for the response, Andrew. - -- Thanks, Rajan. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html

Re: Able to do ALTER DEFAULT PRIVILEGES from a user who is not the owner

Andrew, Another question, If the user student is not the owner of the Schema(additional) and has only USAGE / no privileges, How come it is able to modify permissions at schema level? - -- Thanks, Rajan. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html

Re: Able to do ALTER DEFAULT PRIVILEGES from a user who is not the owner

Thanks Andrew for the reply. Based on the answer, Is there a way to provide read access on all tables( *created by any user* ) to a Read Only user? - -- Thanks, Rajan. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html

Re: vacuum and autovacuum - is it good to configure the threshold at TABLE LEVEL?

analyse_threshold set at 300, how can only analyse run and vacuum does not? This may be a stupid question. But any answer can help me understand. - -- Thanks, Rajan. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html

Re: vacuum and autovacuum - is it good to configure the threshold at TABLE LEVEL?

Thanks for the reply Amul. Btw, No my table does not has any index. - -- Thanks, Rajan. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html

Is there any way that one of the Postgres Background/Utility process may go down?

Is there any way that one of the Postgres Background process may go down? meaning the process getting stopped? For example, can the wal sender process alone stop working? If it does so, which part of the logs I must check to proceed further. - -- Thanks, Rajan. -- Sent from: http

Possible to exclude a database from loading a shared_preload_libraries module?

- Regards Rajan Pandey

[no subject]

esql % cat > /usr/local/pgsql/data/postgresql.auto.conf > cat: /usr/local/pgsql/data/postgresql.auto.conf: Permission denied rajanx@b0be835adb74 postgresql % su cat > /usr/local/pgsql/data/postgresql.auto.conf > Password: > su: Sorry > Please help! Thank you. :) -- Regards Rajan Pandey

Why is 'use_alias' hardcoded to true in deparseFromExprForRel() for some cases

ign server will do SCAN only, and the JOIN will happen at the upper layer). In that case, using aliases in the remote queries seem redundant to me. Please correct me if I am missing something. Can we note pass `bms_membership(foreignrel->relids) == BMS_MULTIPLE` instead? -- Regards Rajan Pandey Software Developer, AWS