table size performace

From: Matthew Peter <survivedsushi(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: table size performace
Date: 2005-09-07 08:01:11
Message-ID: 20050907080111.88060.qmail@web35206.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2005-09-07 09:30:50 Re: table size performace
Previous Message Jürgen Rose 2005-09-07 06:50:27 Re: SLOOOOOOOW