Re: [ADMIN] max_fsm_relations

Adam Radłowski wrote: > So, are You suggesting, that at the time of full database vacuuming, > some of tables are not vacuumed, when "max_fsm_relations" is to small ? No. They will all be vacuumed. The difference is that the space reclaimed by vacuum will not be reused unless it is recorded by

[ADMIN] Not so simple query and a half million loop

I've tryied 4 times to post this message to pgsql-performance without success... No return, even an error... Below is my problem; a query that perform bad when using a filter almost equal. The problem (8.2.11): EXPLAIN ANALYZE SELECT resource, category, userid, title, year, month, SUM(hours) FROM

Re: [ADMIN] Not so simple query and a half million loop

Maybe someone would like to see it without broken lines (I do). Regards, 2008/12/1 Daniel Cristian Cruz <[EMAIL PROTECTED]>: > I've tryied 4 times to post this message to pgsql-performance without > success... No return, even an error... > > Below is my problem; a query that perform bad when usin

Re: [ADMIN] max_fsm_relations

Now I got full information. Big thanks. Adam Alvaro Herrera pisze: Adam Radłowski wrote: So, are You suggesting, that at the time of full database vacuuming, some of tables are not vacuumed, when "max_fsm_relations" is to small ? No. They will all be vacuumed. The difference is that the sp

[ADMIN] change user passwd

I'm using PG 8.3.4 , what's the method for remote users to change their PG passwd . Isabella -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] Logging autovacuum

Hi All; I wonder is there a way to force autovacuum events to be logged to the postgres log ? Thanks in advance -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Logging autovacuum

On Mon, 2008-12-01 at 21:35 -0700, Kevin Kempter wrote: > > Hi All; > > I wonder is there a way to force autovacuum events to be logged to the > postgres log ? I believe they are, if you turn it up to DEBUG or DEBUG2. Joshua D. Drake > > > Thanks in advance > -- PostgreSQL Consulting,

Re: [ADMIN] change user passwd

How the remote user access the postgres database. Are they using pgadmin ?? Are they able to connect through psql to remote database? IF yes then try following command dbname=# alter user "Username" password 'password'; In pgadmin tool we can directly edit the user user properties & change t