Sai Hertz And Control Systems <sank89@sancharnet.in> 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 page, and
therefore you'll need fewer pages and less disk space. However, I'd be
surprised if the performance improvement is very significant.
> 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 application break at any point
No.
BTW, we intend to phase out the use of OIDs for user tables in the
long term. There have been a few threads on -hackers that discuss the
plans for doing this.
-Neil