pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Sai Hertz And Control Systems <sank89@sancharnet.in>
To: pgsql-admin@postgresql.org
Cc: pgsql-performance@postgresql.org
Subject: Tables Without OIDS and its effect
Date: Fri, 12 Dec 2003 21:43:10 +0530
Message-ID: <3FD9E916.8050005@sancharnet.in> (raw)

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 application break at any point
3. I decided to  work with out OIDS because
  1. It has a limit of  -2147483648 to +2147483647
  2 Due to this limitation I would not like to drop recreate my 
database because it is a bit difficult/dirty process

All links and suggestion pertaining to OIDS are most welcome my mail box 
is at your  disposal and dont  hassitate to
drop a two line comment.
-----------------------
My Sys Config:
RH                9.0
PostgreSQL  7.3.4
GCC             3.2.2
PHP              4.3.4
----------------------
Regards,
V Kashyap






view thread (5+ messages)  latest in thread

Message-ID: <3FD9E916.8050005@sancharnet.in>
Permalink:  ../3FD9E916.8050005@sancharnet.in/
Also on:    postgresql.org/message-id/3FD9E916.8050005@sancharnet.in

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: sank89@sancharnet.in, pgsql-admin@postgresql.org
  Subject: Re: Tables Without OIDS and its effect
  In-Reply-To: <3FD9E916.8050005@sancharnet.in>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox