From: | M(dot)Feldtmann(at)t-online(dot)de (Marten Feldtmann) |
---|---|
To: | John Menke <john(at)eagleinfosystems(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Performance Issues |
Date: | 2001-01-11 07:30:27 |
Message-ID: | 3A5D6113.86CD1A8C@toppoint.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> John Menke schrieb:
>
> I am in the design phase of a new database that contains one very long
> thin table. Are there any peformance issues with index lookups to a
> table like this if table becomes extremly long? Lets say hundreds of
> thousands to millions of records... Remember, the table only has one
> column.
>
> Another question. If the size of data in this record were to vary
> greatly, would that have an impact on performance?
>
>
insert and updates times may grow linear if you've indices,
otherwise selects will be pretty stable.
Marten
From | Date | Subject | |
---|---|---|---|
Next Message | Henk van Lingen | 2001-01-11 09:07:35 | Re: automatic timestamp question |
Previous Message | Mike Cannon-Brookes | 2001-01-11 07:28:34 | RE: PostgreSQL v7.1BETA3 Bundled and Available ... |