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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
