From: Andrew McMillan <andrew@catalyst.net.nz>
To: Eric Lauzon <eric.lauzon@abovesecurity.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: OID vs overall system performances on high load
Date: Mon, 30 May 2005 09:46:43 +1200
Message-ID: <1117403203.30150.206.camel@lamb.mcmillan.net.nz> (raw)
In-Reply-To: <F7B73864DD39FA40B6C56B3CE0D4D1CB1B4466@asdc003.abovesecurite.lan>
References: <F7B73864DD39FA40B6C56B3CE0D4D1CB1B4466@asdc003.abovesecurite.lan>
On Sun, 2005-05-29 at 16:17 -0400, Eric Lauzon wrote:
> I am still in the dark due to my lack of knowledge on internal OID management,but
> i would presume that a table with OID enable and that has high load would require
> some more work from pgsql internal to maintain the OID index for the database.
>
> So OID can be beneficial on static tables, or tables that you want to be able to manipulate
> with pgadmin X , but can a table without OID increase performances on insert,delete,update,COPY?
>
> I am not really worried about disk space that an OID collumn can take, but i was wandering if an
> insert in a table of 20 millions and more that has oid would slow the insert process. Since OID seem
> to act as a global index mabey maintaning that index can become costy over high table load by postgresql
> backend.
There is no OID index, unless you create one.
The disk space that an OID column can take has an effect on performance:
reducing the amount of physical disk reads will mean that more of your
real data is cached, and so forth. How much effect it will have will
depend on the relative size of the OID column and the other columns in
your data.
Regards,
Andrew McMillan.
-------------------------------------------------------------------------
Andrew @ Catalyst .Net .NZ Ltd, PO Box 11-053, Manners St, Wellington
WEB: http://catalyst.net.nz/ PHYS: Level 2, 150-154 Willis St
DDI: +64(4)803-2201 MOB: +64(272)DEBIAN OFFICE: +64(4)499-2267
http://survey.net.nz/ - any more questions?
-------------------------------------------------------------------------
Attachments:
signature.asc (application/pgp-signature, 188B) download
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: andrew@catalyst.net.nz, eric.lauzon@abovesecurity.com
Subject: Re: OID vs overall system performances on high load
In-Reply-To: <1117403203.30150.206.camel@lamb.mcmillan.net.nz>
References: <F7B73864DD39FA40B6C56B3CE0D4D1CB1B4466@asdc003.abovesecurite.lan> <1117403203.30150.206.camel@lamb.mcmillan.net.nz>
* 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