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 ===