Malcolm,
> Would it make sense to dynamically adjust the buffers during updates?
>
It can be very inconvenient if you run them often. Moreover, this won't
solve the main problem (at least I think that this is the main reason) -
memory consumption. It's quite possible to run several queries which
require all available memory.
Probably, you should try to create swap file:
https://forums.aws.amazon.com/thread.jspa?threadID=53053
Does the command line -bufs-num override the -bufs-num value set in the
> dbname configuration file?
>
Yes.
BTW, what's the 'top' output when bug happens? Just to understand exact
memory consumption by se_trn processes.
Ivan
------------------------------------------------------------------------------
Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
infrastructure or vast IT resources to deliver seamless, secure access to
virtual desktops. With this all-in-one solution, easily deploy virtual
desktops for less than the cost of PCs and save 60% on VDI infrastructure
costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
