From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Complete row is fetched ? |
Date: | 2010-04-16 06:18:13 |
Message-ID: | 20100416061812.GB9356@a-kretschmer.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
Regards, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Smith | 2010-04-16 06:50:58 | Re: readline library not found |
Previous Message | John R Pierce | 2010-04-16 06:11:02 | Re: Complete row is fetched ? |