Re: [EXTERNAL] Re: Crash in record_type_typmod_compare

2021-04-05 Thread Sait Talha Nisanci
Hi Andres, Please see the updated patch, do you mean something like this? (there might be a simpler way for doing this) Best, Talha. From: Andres Freund Sent: Wednesday, March 31, 2021 10:49 PM To: Sait Talha Nisanci Cc: pgsql-hackers ; Metin Doslu Subject

Re: Crash in record_type_typmod_compare

2021-03-31 Thread Sait Talha Nisanci
e error happens. I will share a fix in this >thread soon. I am attaching this patch. ________ From: Sait Talha Nisanci Sent: Wednesday, March 31, 2021 11:50 AM To: pgsql-hackers Cc: Metin Doslu Subject: Crash in record_type_typmod_compare Hello, In citus,

Crash in record_type_typmod_compare

2021-03-31 Thread Sait Talha Nisanci
Hello, In citus, we have seen the following crash backtraces because of a NULL tupledesc multiple times and we weren't sure if this was related to citus or postgres: #0 equalTupleDescs (tupdesc1=0x0, tupdesc2=0x1b9f3f0) at tupdesc.c:417 417 tupdesc.c: No such file or directory. #0 equalT

RE: [EXTERNAL] Re: WIP: WAL prefetch (another approach)

2020-09-01 Thread Sait Talha Nisanci
en Frost Sent: Sunday, August 30, 2020 3:24 PM To: Tomas Vondra Cc: Robert Haas ; Andres Freund ; Sait Talha Nisanci ; Thomas Munro ; Dmitry Dolgov <9erthali...@gmail.com>; David Steele ; Alvaro Herrera ; pgsql-hackers Subject: Re: [EXTERNAL] Re: WIP: WAL prefetch (another approach)

RE: [EXTERNAL] Re: WIP: WAL prefetch (another approach)

2020-08-27 Thread Sait Talha Nisanci
Hi Stephen, OS version is Ubuntu 18.04.5 LTS. Filesystem is ext4 and block size is 4KB. Talha. -Original Message- From: Stephen Frost Sent: Thursday, August 27, 2020 4:56 PM To: Sait Talha Nisanci Cc: Thomas Munro ; Tomas Vondra ; Dmitry Dolgov <9erthali...@gmail.com>; David

RE: [EXTERNAL] Re: WIP: WAL prefetch (another approach)

2020-08-26 Thread Sait Talha Nisanci
I have run some benchmarks for this patch. Overall it seems that there is a good improvement with the patch on recovery times: The VMs I used have 32GB RAM, pgbench is initialized with a scale factor 3000(so it doesn’t fit to memory, ~45GB). In order to avoid checkpoints during benchmark, max_w