RE: OID Perfomance - Object-Relational databases
От | Michael Ansley |
---|---|
Тема | RE: OID Perfomance - Object-Relational databases |
Дата | |
Msg-id | 7F124BC48D56D411812500D0B7472514061451@fileserver002.intecsystems.co.uk обсуждение исходный текст |
Ответ на | OID Perfomance - Object-Relational databases (Josh Berkus <josh@agliodbs.com>) |
Список | pgsql-sql |
<p><font size="2">Hi, Josh,</font><p><font size="2">In fact, the last point about OIDs is particularly pertinent, becausewe are expected to process up to 500 million records daily, thus exhausting the limit in, um, eight days.</font><p><fontsize="2">Is anybody aware of when this limit will be raised.</font><p><font size="2">Cheers...</font><p><fontsize="2">>> -----Original Message-----</font><br /><font size="2">>> From:Josh Berkus [<a href="mailto:josh@agliodbs.com">mailto:josh@agliodbs.com</a>]</font><br /><font size="2">>> Sent: 03 October 2000 17:06</font><br /><font size="2">>> To: sqllist</font><br /><font size="2">>> Cc: Jeff MacDonald</font><br /><font size="2">>> Subject: [SQL] OID Perfomance - Object-Relationaldatabases</font><br /><font size="2">>> </font><br /><font size="2">>> </font><br /><fontsize="2">>> Folks,</font><br /><font size="2">>> </font><br /><font size="2">>> Becauseit's a very elegant solution to my database </font><br /><font size="2">>> structure issues,</font><br /><fontsize="2">>> I'm using OID's extensively as referents and foriegn keys. </font><br /><font size="2">>> However, I</font><br /><font size="2">>> wanted to see if others had previous experience in this</font><br /><font size="2">>> (answer as many</font><br /><font size="2">>> as you like):</font><br/><font size="2">>> </font><br /><font size="2">>> 1. Is there a performance loss on searchesand joins when </font><br /><font size="2">>> I use the OID</font><br /><font size="2">>> as a linikingfield as opposed to a SERIAL column?</font><br /><font size="2">>> </font><br /><font size="2">>> 2. Can I define my own index on the OIDs of a table?</font><br /><font size="2">>> </font><br/><font size="2">>> 3. What is the difference between these two DDL statements </font><br /><font size="2">>> in terms of</font><br /><font size="2">>> data access and PG-SQL performance (assuming that tableclients has</font><br /><font size="2">>> already been defined):</font><br /><font size="2">>> </font><br/><font size="2">>> CREATE TABLE client_addresses AS (</font><br /><font size="2">>> client_OID OID REFERENCES clients,</font><br /><font size="2">>> address1 VARCHAR (30),</font><br/><font size="2">>> address2 VARCHAR (30),</font><br /><font size="2">>> address3 VARCHAR (30)</font><br /><font size="2">>> )</font><br /><font size="2">>> and:</font><br/><font size="2">>> CREATE TABLE client_addresses AS (</font><br /><font size="2">>> client clients,</font><br /><font size="2">>> address1 VARCHAR (30),</font><br /><font size="2">>> address2 VARCHAR (30),</font><br /><font size="2">>> address3 VARCHAR (30)</font><br/><font size="2">>> )</font><br /><font size="2">>> </font><br /><font size="2">>> (This is Michael's questions rephrased)</font><br /><font size="2">>> </font><br /><font size="2">>> 4. Int4 seems kinda small to me for a value that needs to enumerate</font><br /><font size="2">>> every single database object. Within a couple of years of </font><br /><font size="2">>> heavyuse, a</font><br /><font size="2">>> customer-transaction database could easily exceed 2 billion objects</font><br/><font size="2">>> created (and destroyed). Are there plans to expand this to Int8?</font><br/><font size="2">>> </font><br /><font size="2">>> -Josh Berkus</font><br /><font size="2">>> </font><br /><font size="2">>> P.S. My aplolgies if I've already posted these questions; I never</font><br/><font size="2">>> received them back from the list mailer.</font><br /><font size="2">>> </font><br /><font size="2">>> </font><br /><font size="2">>> </font><br /><font size="2">>> -- </font><br /><font size="2">>> ______AGLIO DATABASE SOLUTIONS___________________________</font><br/><font size="2">>> Josh Berkus</font><br/><font size="2">>> Complete information technology josh@agliodbs.com</font><br /><font size="2">>> and data management solutions (415) 436-9166</font><br /><font size="2">>> for lawfirms, small businesses fax 436-0137</font><br /><font size="2">>> and non-profit organizations. pager 338-4078</font><br /><font size="2">>> San Francisco</font><br/><font size="2">>> </font>
В списке pgsql-sql по дате отправления: