Thread: Max registers in postgresql 7.4
Hello, I'm having trouble in find certain information, i've search over the web and through the documentation but i haven't had lucky. I need to know if there is some limit in the amount of registers that the database can manage, and if so, how much is that maximun. Thanks in advanced, Ruby. _________________________________________________________________ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail
"Ruby Deepdelver" <janettedoe@hotmail.com> writes: > Hello, I'm having trouble in find certain information, i've search > over the web and through the documentation but i haven't had lucky. > I need to know if there is some limit in the amount of registers that > the database can manage, and if so, how much is that maximun. Ummm... What is a 'register'? That's not a standard database term AFAIK and it does not have any meaning with respect to PostgreSQL. That's probably why you couldn't find anything. :) -Doug
Mensaje citado por Doug McNaught <doug@mcnaught.org>:
> "Ruby Deepdelver" <janettedoe@hotmail.com> writes:
>
> > Hello, I'm having trouble in find certain information, i've search
> > over the web and through the documentation but i haven't had lucky.
> > I need to know if there is some limit in the amount of registers that
> > the database can manage, and if so, how much is that maximun.
>
> Ummm... What is a 'register'? That's not a standard database term
> AFAIK and it does not have any meaning with respect to PostgreSQL.
> That's probably why you couldn't find anything. :)
Doug, you forgot to say what the term really is: TUPLE
--
select 'mmarques' || '@' || 'unl.edu.ar' AS email;
---------------------------------------------------------
Martín Marqués | Programador, DBA
Centro de Telemática | Administrador
Universidad Nacional
del Litoral
---------------------------------------------------------
OK boys, i've made a mistake by using the term "register". What i meant is "record". Could you please tell me if there's a limit in the amount of records that the database can handle? Thanks... Ruby Martin: why do you say i meant tuple? >From: Martin Marques <martin@bugs.unl.edu.ar> >To: Doug McNaught <doug@mcnaught.org> >CC: Ruby Deepdelver <janettedoe@hotmail.com>, pgsql-general@postgresql.org >Subject: Re: [GENERAL] Max registers in postgresql 7.4 >Date: Wed, 14 Jan 2004 17:54:44 -0300 > >Mensaje citado por Doug McNaught <doug@mcnaught.org>: > > > "Ruby Deepdelver" <janettedoe@hotmail.com> writes: > > > > > Hello, I'm having trouble in find certain information, i've search > > > over the web and through the documentation but i haven't had lucky. > > > I need to know if there is some limit in the amount of registers that > > > the database can manage, and if so, how much is that maximun. > > > > Ummm... What is a 'register'? That's not a standard database term > > AFAIK and it does not have any meaning with respect to PostgreSQL. > > That's probably why you couldn't find anything. :) > >Doug, you forgot to say what the term really is: TUPLE > _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus
"Ruby Deepdelver" <janettedoe@hotmail.com> writes: > Could you please tell me if there's a limit in the amount of records that > the database can handle? See the FAQ: http://www.postgresql.org/docs/faqs/FAQ.html#4.5 regards, tom lane
On Friday 16 January 2004 16:10, Ruby Deepdelver wrote: > OK boys, i've made a mistake by using the term "register". What i meant is > "record". > Could you please tell me if there's a limit in the amount of records that > the database can handle? > Thanks... Ruby > Martin: why do you say i meant tuple? Tuple, row and record tend to be used interchangeably. You want this page: http://www.postgresql.org/users-lounge/limitations.html -- Richard Huxton Archonet Ltd
janettedoe@hotmail.com ("Ruby Deepdelver") writes:
> Hello, I'm having trouble in find certain information, i've search
> over the web and through the documentation but i haven't had lucky.
> I need to know if there is some limit in the amount of registers that
> the database can manage, and if so, how much is that maximun.
> Thanks in advanced, Ruby.
It is not evident what you mean by "registers."
The meaning I usually take is nicely documented in FOLDOC:
<http://wombat.doc.ic.ac.uk/foldoc/foldoc.cgi?register>
"register
1. One of a small number of high-speed memory locations in a
computer's CPU. Registers differ from ordinary random access memory in
several respects:
There are only a small number of registers (the "register set"),
typically 32 in a modern processor though some, e.g. SPARC, have as
many as 144. A register may be directly addressed with a few bits. In
contrast, there are usually millions of words of main memory (RAM),
requiring at least twenty bits to specify a memory location. Main
memory locations are often specified indirectly, using an indirect
addressing mode where the actual memory address is held in a register.
Registers are fast; typically, two registers can be read and a third
written -- all in a single cycle. Memory is slower; a single access
can require several cycles.
The limited size and high speed of the register set makes it one of
the critical resources in most computer architectures. Register
allocation, typically one phase of the back-end, controls the use of
registers by a compiled program."
Databases don't usually manage registers; that normally involves some
combination of the operating system (which may have some conventions
as to what registers are used for what purposes) and the compilers
used to compile code.
The "maximum number of registers" is normally a function of what the
manufacturer of your computer's CPU has designed; DBMS implementors
cannot increase the number.
--
let name="cbbrowne" and tld="libertyrms.info" in String.concat "@" [name;tld];;
<http://dev6.int.libertyrms.com/>
Christopher Browne
(416) 646 3304 x124 (land)