Re: PostgreSQL Process memory architecture

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Atri Sharma <atri(dot)jiit(at)gmail(dot)com>
Cc: "Ben Zeev, Lior" <lior(dot)ben-zeev(at)hp(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PostgreSQL Process memory architecture
Date: 2013-05-27 12:45:00
Message-ID: 20130527124500.GO8597@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

* Atri Sharma (atri(dot)jiit(at)gmail(dot)com) wrote:
> It is just a hunch, but all of your attributes are character varying.
> Could TOAST be an issue here?

TOAST tables are only created when needed. In addition, I believe
Lior's concerned about memory utilization and not disk usage; memory
utilization should not be impacted by TOAST at all unless large values
in the tables (which had to be moved to a TOAST table due to size) are
actually being queried against.

Thanks,

Stephen

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2013-05-27 13:01:35 Re: PostgreSQL Process memory architecture
Previous Message Stephen Frost 2013-05-27 12:42:54 Re: PostgreSQL Process memory architecture