RAM-only temporary tables
От | Kevin Grittner |
---|---|
Тема | RAM-only temporary tables |
Дата | |
Msg-id | 4911D148.EE98.0025.0@wicourts.gov обсуждение исходный текст |
Ответы |
Re: RAM-only temporary tables
Re: RAM-only temporary tables Re: RAM-only temporary tables |
Список | pgsql-hackers |
An idea for a possible enhancement to PostgreSQL: allow creation of a temporary table without generating any disk I/O. (Creating and dropping a three-column temporary table within a database transaction currently generates about 150 disk writes). If some circumstances don't make it feasible to always do this as a RAM-only operation, perhaps a clause could be added to the CREATE TEMPORARY TABLE syntax to specify this behavior along with whatever limitations on the temporary table are required for this to work. (For example, maybe this is only feasible if the table will be dropped by the end of the transaction?) -Kevin
В списке pgsql-hackers по дате отправления: