Does PostgreSQL use atomic file creation of FS?

2018-12-12 Thread Dmitry Lazurkin
Hello. Does PostgreSQL use atomic file creation on FS? How does PostgreSQL catch situation when system crashes between open call and write call? I am interesting in this because I would like use PostgreSQL on network file system. Thank you.

Re: Does PostgreSQL use atomic file creation of FS?

2018-12-12 Thread Dmitry Lazurkin
fsync(fd); PS. I think PostgreSQL doesn't have this problem. On 12/12/18 15:37, Karsten Hilbert wrote: > On Wed, Dec 12, 2018 at 02:48:12PM +0300, Dmitry Lazurkin wrote: > >> Does PostgreSQL use atomic file creation on FS? How does PostgreSQL >> catch situation when syst

Implementation of gtrgm_out for gevel

2017-11-23 Thread Dmitry Lazurkin
Hello. I want use gevel (http://www.sai.msu.su/~megera/wiki/Gevel) for investigation of pg_trgm gist. But for gist_print i need implement gtrgm_out for pg_trgm gist node. And i have a problem here. - My version: PostgreSQL 9.6.6 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubun

Re: Implementation of gtrgm_out for gevel

2017-11-23 Thread Dmitry Lazurkin
On 23.11.2017 21:58, Tom Lane wrote: > Dmitry Lazurkin writes: >> Datum >> gtrgm_out(PG_FUNCTION_ARGS) >> { >>     GISTENTRY  *entry = (GISTENTRY *) PG_GETARG_POINTER(0); /* I think entry >> is pointer to bad memory */ > The argument is TRGM *,

Re: Implementation of gtrgm_out for gevel

2017-11-24 Thread Dmitry Lazurkin
On 11/23/2017 09:58 PM, Tom Lane wrote: > Dmitry Lazurkin writes: >> Datum >> gtrgm_out(PG_FUNCTION_ARGS) >> { >>     GISTENTRY  *entry = (GISTENTRY *) PG_GETARG_POINTER(0); /* I think entry >> is pointer to bad memory */ > The argument is TRGM *,