| From: | "A(dot) Kretschmer" <akretschmer(at)despammed(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: table size performace |
| Date: | 2005-09-07 09:30:50 |
| Message-ID: | 20050907093049.GG18174@webserv.wug-glas.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 ===
| From | Date | Subject | |
|---|---|---|---|
| Next Message | nicolas hafner | 2005-09-07 11:21:23 | 64 bits? |
| Previous Message | Matthew Peter | 2005-09-07 08:01:11 | table size performace |