X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8F70B5293D for ; Sun, 29 May 2005 18:46:58 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 41332-03 for ; Sun, 29 May 2005 21:46:54 +0000 (GMT) Received: from mail1.catalyst.net.nz (godel.catalyst.net.nz [202.49.159.12]) by svr1.postgresql.org (Postfix) with ESMTP id B19C0528C5 for ; Sun, 29 May 2005 18:46:45 -0300 (ADT) Received: from leibniz.catalyst.net.nz ([202.49.159.7] helo=lamb.mcmillan.net.nz) by mail1.catalyst.net.nz with asmtp (TLS-1.0:DHE_RSA_3DES_EDE_CBC_SHA:24) (Exim 4.34) id 1DcVcL-0006um-5I; Mon, 30 May 2005 09:46:45 +1200 Received: from lamb.mcmillan.net.nz (lamb.mcmillan.net.nz [127.0.0.1]) by lamb.mcmillan.net.nz (Postfix) with ESMTP id 3D8FDAD98581; Mon, 30 May 2005 09:46:43 +1200 (NZST) Subject: Re: OID vs overall system performances on high load From: Andrew McMillan To: Eric Lauzon Cc: pgsql-performance@postgresql.org In-Reply-To: References: Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-GovVMaTAy3jtklj3CzlR" Date: Mon, 30 May 2005 09:46:43 +1200 Message-Id: <1117403203.30150.206.camel@lamb.mcmillan.net.nz> Mime-Version: 1.0 X-Mailer: Evolution 2.2.2 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200505/425 X-Sequence-Number: 12589 --=-GovVMaTAy3jtklj3CzlR Content-Type: text/plain Content-Transfer-Encoding: quoted-printable 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 manage= ment,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 data= base. > =20 > 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 ins= ert,delete,update,COPY? > =20 > I am not really worried about disk space that an OID collumn can take, bu= t i was wandering if an=20 > insert in a table of 20 millions and more that has oid would slow the ins= ert process. Since OID seem > to act as a global index mabey maintaning that index can become costy ove= r 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? ------------------------------------------------------------------------- --=-GovVMaTAy3jtklj3CzlR Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQBCmjhCjJA0f48GgBIRAsNvAJ4k9hsLUrlSfYFtu0Zevcy1SyiUIgCdGcOL UnB1QivvEsV3KZqWntZPRB4= =EpBo -----END PGP SIGNATURE----- --=-GovVMaTAy3jtklj3CzlR--