Re: [GENERAL] Prefetch children

On Sat, 2004-09-18 at 07:42, Ioannis Theoharis wrote: > I'd like to ask you, > if postgres prefetch child instances in memory , > whenever a parent table is sequentially scanned, > in order to have them in there > for the possibility the next query to ask for them. I'm not sure exactly what you're

Re: [GENERAL] order of row processing affects updates

hi all! thanks for all the feedback on row processing order. I agree with Greg when he says that the correct way to do this is to set constraints to be deferred. I think trying to predict a correct row processing order would be really complicated and the problem may not scale given the complexity

[GENERAL] using schemas to create a virtual DB?

Hi, I need to give some partners to a read only subset of my data. I'm currently looking at schemas, not something I've looked at or used before. Can I use schemas to create a virtual DB (built by views) onto my main DB? Or is this a dead end thought? Cheers, Bob This message has been scann

[GENERAL] basics on User Defined Functions

Is this the correct way to return values in a record from a UDF in 7.4.+ ? Is it ok to modify the arguments as in 'arg_int'? -- return type should be RECORD -- CREATE OR REPLACE FUNCTION test_function( int ) RETURNS RECORD AS ' DECLARE arg_int ALIAS FOR $1; var_record_out

Re: [GENERAL] using database for queuing operations?

Oracle also has the NOWAIT option for use with the SELECT ... FOR UPDATE query. If the record is locked, the NOWAIT causes the query to generate an exception (rather than blocking) which can then be caught and handled - it helps prevent race conditions. A very nice feature! John Sidney-Woollett