Thread: table size performace

table size performace

From
Matthew Peter
Date:
How many rows does it take for select performance on a
table to degrade? I hope this question isn't to
ambiguous (ie lollipop licks). But seriously, 100,000?
1,000,000? 10,000,000? With just a regular lookup on
an unique index. Nothing crazy or aggregate.

EX: select * from bigtable where id = 123456789

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Re: table size performace

From
"A. Kretschmer"
Date:
am  07.09.2005, um  1:01:11 -0700 mailte Matthew Peter folgendes:
> How many rows does it take for select performance on a
> table to degrade? I hope this question isn't to
> ambiguous (ie lollipop licks). But seriously, 100,000?
> 1,000,000? 10,000,000? With just a regular lookup on
> an unique index. Nothing crazy or aggregate.
>
> EX: select * from bigtable where id = 123456789

Read http://www.postgresql.org/docs/faqs.FAQ.html#4.4.

If you have a index, a simple select like your example is very fast,
independent of the rows count.


Regards.
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===