Is there a way to find out "which of the 1000 relations" that msx_fsm
will be kept track for. (I am using the default..and vacuumdb
suggested increasing max_fsm_relations)
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql
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
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
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 ?
Thanks for Your fast answer.
Adam
Tom Lane pisze:
=?ISO-8859-2?Q?Adam_Rad=B3owski?= <[EMAIL PROTECTED]> writes:
PostgreSQL 8.1.3 (windows), 8.1.9 - 8.1.1
=?ISO-8859-2?Q?Adam_Rad=B3owski?= <[EMAIL PROTECTED]> writes:
> PostgreSQL 8.1.3 (windows), 8.1.9 - 8.1.10 (linux).
> I have databases, what are vacuumed using cron very regularry (vacuumdb
> -a -f ...) and I know when should do this. Automatic vacuuming is off.
> There are thousands of tables in
PostgreSQL 8.1.3 (windows), 8.1.9 - 8.1.10 (linux).
I have databases, what are vacuumed using cron very regularry (vacuumdb
-a -f ...) and I know when should do this. Automatic vacuuming is off.
There are thousands of tables in one cluster (for ex. 1). If I do
vacuuming manually, I can see
--- Pallav Kalva <[EMAIL PROTECTED]> escribió:
> Hi Everybody,
>
> I want to set max_fsm_relations parameter in
> the postgres.conf file
> is there any way to find out the count of all the
> tables and indexes in all the databases without
> running any vacuum
> verbose commands ?
>
maybe
Hi Everybody,
I want to set max_fsm_relations parameter in the postgres.conf file
is there any way to find out the count of all the
tables and indexes in all the databases without running any vacuum
verbose commands ?
Thanks!
Pallav
---(end of broadcast)--
