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 === ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
