[GENERAL] Help regarding flushing data from Shared Memory to Database - Mailing list pgsql-general

From Naveen Raj
Subject [GENERAL] Help regarding flushing data from Shared Memory to Database
Date
Msg-id CALyVuk4Ki8-Y0kad2ep8RX9Kg-VsTFgD3GZDUSz+fhVOHbeY+w@mail.gmail.com
Whole thread Raw
List pgsql-general
Hi, 
We are currently working on cstore extension. We are storing the all the inserts in a shared memory and then flushing the tuples to the database. We are using a background worker to periodically flush the data. But the problem is we are not able to do the insert the data during the periodic check. I get the following error. "ERROR:  cache lookup failed for foreign table 33321" Is there any possible ways to make this possible. And also before shutting down the postgres I have to flush the data to the database. I try to call the fdw routine that is used to flush the data to database. But I get an error again saying "FATAL:  invalid cache ID: 31".

Naveen.

pgsql-general by date:

Previous
From: mac pack
Date:
Subject: [GENERAL] Recovery damaged dump file
Next
From: Naveen Raj
Date:
Subject: [GENERAL] Help regarding flushing data from Shared Memory to Database