Re: Re: Speed of locating tables - Mailing list pgsql-general

From Richard Harvey Chapman
Subject Re: Re: Speed of locating tables
Date
Msg-id Pine.LNX.4.10.10006010114560.17141-100000@smile.3gfp.com
Whole thread Raw
In response to Re: Re: Speed of locating tables  (Jurgen Defurne <defurnj@glo.be>)
List pgsql-general
On Thu, 1 Jun 2000, Jurgen Defurne wrote:

> could cache it, but then you will need (at an estimate of 128 bytes
> per inode) probably about 32 MB of RAM (at 1/100th of the real space
> needed), which doesn't seem to bad, but which could be used more
> productively.

the last 1TB machine I saw came with > 5GB of RAM.  32MB sounds
reasonable.

all kidding aside, I'd have to agree that the I/O issue sounds rather
negative.

R.



pgsql-general by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: RE: CREATE USER
Next
From: Ron Chmara
Date:
Subject: Re: Re: [HACKERS] Oft Ask: How to contribute to PostgreSQL?