Re: Is there a cache consistent interface to tables ?

On 11 February 2018 at 04:44, Gary M wrote: > Thanks Craig, > > As I'm back in pg code after many years, I'm feeling much better there's > one (1) or two (2) items causing the hiccup. Rereading your comments, I'm > agreeing with you. I'm considering bumping up the ram to 512gb as a RAM > disk ju

Re: Is there a cache consistent interface to tables ?

Thanks Craig, As I'm back in pg code after many years, I'm feeling much better there's one (1) or two (2) items causing the hiccup. Rereading your comments, I'm agreeing with you. I'm considering bumping up the ram to 512gb as a RAM disk just for consistent profiling (an old bad habit). I'm reas

Re: Is there a cache consistent interface to tables ?

On 10 February 2018 at 14:26, Gary M wrote: > Thanks for the replies. > > @Craig > > Realtime ? well not really. I guess it's your definition of realtime. I > usually think of micro to nano seconds as real-time. If I were still > designing chips, I'd be calling picosecs real-time these days. > H

Re: Is there a cache consistent interface to tables ?

Thanks for the replies. @Craig Realtime ? well not really. I guess it's your definition of realtime.. I usually think of micro to nano seconds as real-time. If I were still designing chips, I'd be calling picosecs real-time these days. Thank you for the recommendation on performance tuning tools

Re: Is there a cache consistent interface to tables ?

On 9 February 2018 at 15:56, Garym wrote: > Hi, > This is an odd request for help. I'm looking to expose an interface so an > external app can insert to a table while maintaining cache consistency and > inserts be promoted via wal. > > I need to support about 100k+ inserts/sec from a sensor data

Re: Is there a cache consistent interface to tables ?

On Fri, Feb 9, 2018 at 12:56 AM, Garym wrote: > Hi, > This is an odd request for help. I'm looking to expose an interface so an > external app can insert to a table while maintaining cache consistency and > inserts be promoted via wal. > ​I don't understand what that all means (what cache? inser

Is there a cache consistent interface to tables ?

Hi, This is an odd request for help. I'm looking to expose an interface so an external app can insert to a table while maintaining cache consistency and inserts be promoted via wal. I need to support about 100k+ inserts/sec from a sensor data stream. It simply won't work using sql queries. I