From: | Yeb Havinga <yebhavinga(at)gmail(dot)com> |
---|---|
To: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Complete row is fetched ? |
Date: | 2010-04-16 07:07:41 |
Message-ID: | 4BC80CBD.7070703@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
A. Kretschmer wrote:
> In response to Satish Burnwal (sburnwal) :
>
>> I have a ques - say I have a table that has 10 columns. But in a simple
>> select query from that table, I use just 3 columns. I want to know
>> whether even for fetching 3 columns, read happens for all the 10 columns
>> and out of that the required 3 columns are returned ? ie Does the
>> complete row with all the 10 columns are fetched even though I need just
>> 3 columns ? OR only 3 columns are fetched ?
>>
>
> Depends, large columns (TEXT, BYTA) are TOASTed¹, that means, the content
> of this columns stored in a other table. So it is always a good idea to
> specify all rows you needed and don't use select *.
>
> ¹ http://www.postgresql.org/docs/8.4/interactive/storage-toast.html
>
Another reason to prefer explicit column lists over SELECT * for queries
on relations with a lot of columsn and rows, is that it enables some
plan nodes to be more economical with memory, see e.g. comment of
'disuse_physical_tlist':
/*
* disuse_physical_tlist
* Switch a plan node back to emitting only Vars actually referenced.
*
* If the plan node immediately above a scan would prefer to get only
* needed Vars and not a physical tlist, it must call this routine to
* undo the decision made by use_physical_tlist(). Currently, Hash, Sort,
* and Material nodes want this, so they don't have to store useless columns.
*/
regards,
Yeb Havinga
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2010-04-16 08:18:45 | Re: Complete row is fetched ? |
Previous Message | Greg Smith | 2010-04-16 06:50:58 | Re: readline library not found |