Re: [HACKERS] Proposal : For Auto-Prewarm.
От
Mithun Cy
Тема
Re: [HACKERS] Proposal : For Auto-Prewarm.
Дата
Msg-id
CAD__OuinNvR71GS9D0-S232CZk09PRfBt1S0ye8akDL0-1AAog@mail.gmail.com
Ответ на
Re: [HACKERS] Proposal : For Auto-Prewarm. (Amit Kapila)
Список
Дерево обсуждения
Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: Proposal : For Auto-Prewarm. "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: Proposal : For Auto-Prewarm. Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Proposal : For Auto-Prewarm. Amit Kapila <amit.kapila16@gmail.com>
Re: Proposal : For Auto-Prewarm. Andres Freund <andres@anarazel.de>
Re: Proposal : For Auto-Prewarm. Robert Haas <robertmhaas@gmail.com>
Re: Proposal : For Auto-Prewarm. Haribabu Kommi <kommi.haribabu@gmail.com>
Re: Proposal : For Auto-Prewarm. Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Proposal : For Auto-Prewarm. Michael Paquier <michael.paquier@gmail.com>
Re: Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: Proposal : For Auto-Prewarm. Haribabu Kommi <kommi.haribabu@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: Proposal : For Auto-Prewarm. andres@anarazel.de (Andres Freund)
Re: [HACKERS] Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Rafia Sabih <rafia.sabih@enterprisedb.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Rafia Sabih <rafia.sabih@enterprisedb.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Thom Brown <thom@linux.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: Proposal : For Auto-Prewarm. Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] Proposal : For Auto-Prewarm. Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Proposal : For Auto-Prewarm. Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
Re: Proposal : For Auto-Prewarm. Mithun Cy <mithun.cy@enterprisedb.com>
On Mon, Jul 3, 2017 at 3:55 PM, Amit Kapila wrote: > On Fri, Jun 23, 2017 at 3:22 AM, Robert Haas wrote: >> On Thu, Jun 15, 2017 at 12:35 AM, Mithun Cy wrote: >> >> * Instead of creating our own buffering system via buffer_file_write() >> and buffer_file_flush(), why not just use the facilities provided by >> the operating system? fopen() et. al. provide buffering, and we have >> AllocateFile() to provide a FILE *; it's just like >> OpenTransientFile(), which you are using, but you'll get the buffering >> stuff for free. Maybe there's some reason why this won't work out >> nicely, but off-hand it seems like it might. It looks like you are >> already using AllocateFile() to read the dump, so using it to write >> the dump as well seems like it would be logical. >> > > One thing that is worth considering is AllocateFile is recommended to > be used for short operations. Refer text atop AllocateFile(). If the > number of blocks to be dumped is large, then the file can remain open > for the significant period of time. -- Agree. I think I need suggestion on this we will hold on to 1 fd, but I am not sure what amount of time file being opened qualify as a case against using AllocateFile(). -- Thanks and Regards Mithun C Y EnterpriseDB: http://www.enterprisedb.com
В списке pgsql-hackers по дате отправления