| From: | Neil Conway <neilc(at)samurai(dot)com> |
|---|---|
| To: | aspire420(at)hotpop(dot)com |
| Cc: | pgsql-admin(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: [PERFORM] Tables Without OIDS and its effect |
| Date: | 2003-12-12 23:10:21 |
| Message-ID: | 87he05pr8i.fsf@mailbox.samurai.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
Sai Hertz And Control Systems <sank89(at)sancharnet(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sai Hertz And Control Systems | 2003-12-13 10:33:37 | Re: [PERFORM] Tables Without OIDS and its effect |
| Previous Message | Bruno Wolff III | 2003-12-12 21:13:33 | Re: PostgreSQL features |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sai Hertz And Control Systems | 2003-12-13 10:33:37 | Re: [PERFORM] Tables Without OIDS and its effect |
| Previous Message | William Yu | 2003-12-12 22:45:31 | Re: Update on putting WAL on ramdisk/ |