Re: [PERFORM] Tables Without OIDS and its effect

2003-12-14 Thread Neil Conway
Tom Lane <[EMAIL PROTECTED]> writes: > I don't believe anyone has proposed removing the facility > altogether. There's a big difference between making the default > behavior be not to have OIDs and removing the ability to have OIDs. Right, that's what I had meant to say. Sorry for the inaccuracy.

Re: [PERFORM] Tables Without OIDS and its effect

2003-12-14 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > BTW, we intend to phase out the use of OIDs for user tables in the > long term. I don't believe anyone has proposed removing the facility altogether. There's a big difference between making the default behavior be not to have OIDs and removing the ability

Re: [PERFORM] Tables Without OIDS and its effect

2003-12-13 Thread Sai Hertz And Control Systems
Hello  Neil Conway, We are doing some test on our applications and will let know the community  if without OIDS we could gain more speed . 2. Though I have not written any code in my any of the pgsql functions which depend on OIDS 1. Will without OIDS the functions behave internally

Re: [PERFORM] Tables Without OIDS and its effect

2003-12-12 Thread Neil Conway
Sai Hertz And Control Systems <[EMAIL PROTECTED]> writes: > I have created my tables without OIDS now my doubts are : > 1. Will this speed up the data insertion process Slightly. It means that each inserted row will be 4 bytes smaller (on disk), which in turn means you can fit more tuples on a p

[PERFORM] Tables Without OIDS and its effect

2003-12-12 Thread Sai Hertz And Control Systems
Dear all , I have created my tables without OIDS now my doubts are : 1. Will this speed up the data insertion process 2. Though I have not written any code in my any of the pgsql functions which depend on OIDS 1. Will without OIDS the functions behave internally differently 2. Will my applica