| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
| Cc: | "Leif B(dot) Kristensen" <leif(at)solumslekt(dot)org>, pgsql general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: psql is slow and it does not take much resources |
| Date: | 2006-05-04 21:12:34 |
| Message-ID: | 1146777154.22037.59.camel@state.g2switchworks.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 2006-05-04 at 16:06, Jim C. Nasby wrote:
> On Thu, May 04, 2006 at 10:58:24PM +0200, Leif B. Kristensen wrote:
> > I know that there is one hard-wired limit due to the OID wrap-around
> > problem, at 2^31 commands in one transaction. But the practical limit
> > due to hardware resources is probably much lower.
>
> This has nothing to do with OIDs, and in fact I don't believe there's
> any intrinsic reason why you couldn't insert more than 2B records in a
> table with OIDs so long as you don't have a unique index defined on it.
But there is a truth there. Most people are far more likely to be
limited by their machine's hardware than by the database at this point.
Of course, SOMEONE will find a way to hit the limit.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2006-05-04 21:29:14 | Re: how can i view deleted records? |
| Previous Message | Jim C. Nasby | 2006-05-04 21:06:51 | Re: psql is slow and it does not take much resources |