currval sequence memory storage?

Поиск
Список
Период
Сортировка
Искать
От
chris.gamble@CPBINC.com
Тема
currval sequence memory storage?
Дата
Msg-id
00CA54A79070D411A9E20090273CEF1C14F3FD@inet1.cpbinc.com
Список
Дерево обсуждения
currval sequence memory storage? chris.gamble@CPBINC.com
Re: currval sequence memory storage? Tom Lane <tgl@sss.pgh.pa.us>
I am using jdbc against postgres 7.2.1. My tables are all designed with a
serial field as the prmiary key. When I perform inserts, I have found
through FAQ's that I can use currval to get the last value used for the
sequence that is unique to my process. My questions is, when does the memory
storage used for this currval get released and what triggers its release? If
it is never released, does that cause the process to consume excessive
memory after several inserts across multiple tables? 


Thanks,
В списке pgsql-general по дате отправления
От: Tom Lane
Дата:
От: Tom Lane
Дата:
FAQ