Re: Regarding Postgres Dynamic Shared Memory (DSA)

Hi Dilip,

Thanks for your response.

The steps you followed are right. May i know in which OS you tried? Mac/Linux.

Because, In Mac, it is working fine. just as expected. But the problem(segmentation fault) i'm facing is with linux systems.

Thanks & Best Regards,

-Mahi
Teamwork divides the task and multiplies the success.

---- On Tue, 20 Jun 2017 16:47:24 +0530 Dilip Kumar <dilipbalaut(at)gmail(dot)com> wrote ----

On Tue, Jun 20, 2017 at 3:16 PM, Mahendranath Gurram

<mahendranath(at)zohocorp(dot)com> wrote:

> Hi Thomas,

>

> Any update on this?

>

> Please let me know how can i proceed further.

>

> Thanks & Best Regards,

> -Mahi

I did not see the code but just tested with your code.

1) Added test_dsa to shared preload library.

2) CREATE EXTENSION test_dsa;

3) executed test_dsa_data_access(1)

postgres=# select test_dsa_data_access(1);

2017-06-20 16:49:39.483 IST [9738] LOG: Data read is ==> Hello world

2017-06-20 16:49:39.483 IST [9738] STATEMENT: select test_dsa_data_access(1);

2017-06-20 16:49:39.484 IST [9907] LOG: BackgroundWorker Shared

LinkedList Data read is ==> Hello world0

2017-06-20 16:49:39.484 IST [9907] LOG: BackgroundWorker Shared

LinkedList Data read is ==> Hello world1

2017-06-20 16:49:39.484 IST [9907] LOG: BackgroundWorker Shared

LinkedList Data read is ==> Hello world2

2017-06-20 16:49:39.484 IST [9907] LOG: BackgroundWorker Shared

LinkedList Data read is ==> Hello world3

2017-06-20 16:49:39.484 IST [9907] LOG: BackgroundWorker Shared

LinkedList Data read is ==> Hello world4

2017-06-20 16:49:39.484 IST [9907] LOG: BackgroundWorker Shared

LinkedList Data read is ==> Hello world5

2017-06-20 16:49:39.484 IST [9907] LOG: BackgroundWorker Shared

LinkedList Data read is ==> Hello world6

2017-06-20 16:49:39.484 IST [9907] LOG: BackgroundWorker Shared

LinkedList Data read is ==> Hello world7

2017-06-20 16:49:39.484 IST [9907] LOG: BackgroundWorker Shared

LinkedList Data read is ==> Hello world8

2017-06-20 16:49:39.485 IST [9738] LOG: LinkedList Node Data read is

==> Hello world0

2017-06-20 16:49:39.485 IST [9738] STATEMENT: select test_dsa_data_access(1);

2017-06-20 16:49:39.485 IST [9738] LOG: LinkedList Node Data read is

==> Hello world1

2017-06-20 16:49:39.485 IST [9738] STATEMENT: select test_dsa_data_access(1);

2017-06-20 16:49:39.485 IST [9738] LOG: LinkedList Node Data read is

==> Hello world2

2017-06-20 16:49:39.485 IST [9738] STATEMENT: select test_dsa_data_access(1);

2017-06-20 16:49:39.485 IST [9738] LOG: LinkedList Node Data read is

==> Hello world3

2017-06-20 16:49:39.485 IST [9738] STATEMENT: select test_dsa_data_access(1);

2017-06-20 16:49:39.485 IST [9738] LOG: LinkedList Node Data read is

==> Hello world4

2017-06-20 16:49:39.485 IST [9738] STATEMENT: select test_dsa_data_access(1);

2017-06-20 16:49:39.485 IST [9738] LOG: LinkedList Node Data read is

==> Hello world5

2017-06-20 16:49:39.485 IST [9738] STATEMENT: select test_dsa_data_access(1);

2017-06-20 16:49:39.485 IST [9738] LOG: LinkedList Node Data read is

==> Hello world6

2017-06-20 16:49:39.485 IST [9738] STATEMENT: select test_dsa_data_access(1);

2017-06-20 16:49:39.485 IST [9738] LOG: LinkedList Node Data read is

==> Hello world7

2017-06-20 16:49:39.485 IST [9738] STATEMENT: select test_dsa_data_access(1);

2017-06-20 16:49:39.485 IST [9738] LOG: LinkedList Node Data read is

==> Hello world8

2017-06-20 16:49:39.485 IST [9738] STATEMENT: select test_dsa_data_access(1);

2017-06-20 16:49:39.485 IST [9738] LOG: LinkedList Node Data read is

==> Hello world9

2017-06-20 16:49:39.485 IST [9738] STATEMENT: select test_dsa_data_access(1);

2017-06-20 16:49:39.485 IST [9738] LOG: LinkedList Node Data read is

==> Hello world10

2017-06-20 16:49:39.485 IST [9738] STATEMENT: select test_dsa_data_access(1);

2017-06-20 16:49:39.485 IST [9738] LOG: LinkedList Node Data read is

==> Hello world11

2017-06-20 16:49:39.485 IST [9738] STATEMENT: select test_dsa_data_access(1);

2017-06-20 16:49:39.485 IST [9738] LOG: LinkedList Node Data read is

==> Hello world12

2017-06-20 16:49:39.485 IST [9738] STATEMENT: select test_dsa_data_access(1);

2017-06-20 16:49:39.485 IST [9738] LOG: LinkedList Node Data read is

==> Hello world13

2017-06-20 16:49:39.485 IST [9738] STATEMENT: select test_dsa_data_access(1);

2017-06-20 16:49:39.485 IST [9738] LOG: LinkedList Node Data read is

==> Hello world14

2017-06-20 16:49:39.485 IST [9738] STATEMENT: select test_dsa_data_access(1);

2017-06-20 16:49:39.485 IST [9738] LOG: LinkedList Node Data read is

==> Hello world15

2017-06-20 16:49:39.485 IST [9738] STATEMENT: select test_dsa_data_access(1);

2017-06-20 16:49:39.485 IST [9738] LOG: LinkedList Node Data read is

==> Hello world16

2017-06-20 16:49:39.485 IST [9738] STATEMENT: select test_dsa_data_access(1);

2017-06-20 16:49:39.485 IST [9738] LOG: LinkedList Node Data read is

==> Hello world17

2017-06-20 16:49:39.485 IST [9738] STATEMENT: select test_dsa_data_access(1);

2017-06-20 16:49:39.485 IST [9738] LOG: LinkedList Node Data read is

==> Hello world18

2017-06-20 16:49:39.485 IST [9738] STATEMENT: select test_dsa_data_access(1);

2017-06-20 16:49:39.485 IST [9738] LOG: LinkedList Node Data read is

==> Hello world19

2017-06-20 16:49:39.485 IST [9738] STATEMENT: select test_dsa_data_access(1);

test_dsa_data_access

----------------------

0

I don't see any segmentation fault. Is there some other step which I

have missed.

--

Regards,

Dilip Kumar

EnterpriseDB: http://www.enterprisedb.com

--

Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)

To make changes to your subscription:

http://www.postgresql.org/mailpref/pgsql-hackers