Re: Clarification needed for comment in storage/file/fd.c - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Clarification needed for comment in storage/file/fd.c
Date
Msg-id 20180316002633.GB2666@paquier.xyz
Whole thread Raw
In response to Clarification needed for comment in storage/file/fd.c  (samuel cherukutty <scherukutty@yahoo.com>)
List pgsql-hackers
On Thu, Mar 15, 2018 at 11:22:31AM +0000, samuel cherukutty wrote:
> It states that it behaves as native functions with the handle
> registered to the current subtransaction.
> If it is so, why is it intended for short operations?
> Will it work if I open a file at the start of the transaction and
> close it at the end of the transaction?
> What are the side effects/limitations of these functions?

The maximum number of file descriptors can be tuned using
max_files_per_process, however the more concurrent operations you do,
the higher the risk to run out of them.  Hence limiting them for
short-time operations it preferred to keep things stable.  You actually
never need to hold them that long anyway, and you may want to rethink
what you are doing as well.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: [HACKERS] GSoC 2017: weekly progress reports (week 6)
Next
From: Masahiko Sawada
Date:
Subject: Re: Failed to request an autovacuum work-item in silence