Re: Interaction between Free Space Map an alternate location

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: Interaction between Free Space Map an alternate location
Дата
Msg-id 419CFC21.3080402@fastcrypt.com
обсуждение исходный текст
Ответ на Re: Interaction between Free Space Map an alternate location for a database  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Ok, so the global part of the fsm is just that it is in shared memory.  If certain databases have more
free space they will simply take up more of the fsm. There is no cross database movement of tuples.
( I realized this when I tried to form my next question)

Dave

Tom Lane wrote:
Dave Cramer <pg@fastcrypt.com> writes: 
Can someone explain how the free space map deals with alternate database 
locations?   
It doesn't really care.  It identifies tables by database OID+table OID,
and where they happen to sit physically doesn't matter.
		regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

 

-- 
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Woody Woodring"
Дата:
Сообщение: Re: Query Performance and IOWait
Следующее
От: Sean Chittenden
Дата:
Сообщение: Re: memcached and PostgreSQL