| From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Performance issues of one vs. two split tables. |
| Date: | 2007-05-14 20:58:41 |
| Message-ID: | Pine.LNX.4.64.0705141358120.6830@salmo.appl-ecosys.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 14 May 2007, PFC wrote:
> I did something like that on MySQL some time ago.
> In the Users table there was stuff that other users need to see (like
> his login name, etc), and stuff that only this user needs to see (like his
> preferences).
> So, when displaying posts in the forum, for instance, only a small
> part of the fields in the Users table was needed, the rest was just dead
> weight, that made the table unable to fit in RAM.
> So I split the table, and it was faster.
>
> However, you can also buy more RAM...
Or, use Views without paying more.
Rich
--
Richard B. Shepard, Ph.D. | The Environmental Permitting
Applied Ecosystem Services, Inc. | Accelerator(TM)
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Glaesemann | 2007-05-14 22:09:29 | Re: are foreign keys realized as indexes? |
| Previous Message | Bill Moseley | 2007-05-14 20:53:13 | Re: Performance issues of one vs. two split tables. |