Re: Performance of multiple queries?

On Thu, Apr 21, 2005 at 05:33:12 -0400,
Leif K-Brooks <eurleif(at)gmail(dot)com> wrote:
> I'm wondering about the performance of using one query versus several.
> For instance, how much slower would several queries be:
>
> SELECT name FROM table WHERE id=123;
> SELECT value FROM table WHERE id=123;
> SELECT type FROM table WHERE id=123;
>
> As compared to one larger equivalent query:
>
> SELECT name, value, type FROM table WHERE id=123;

You can probably expect it will take three times as long to do the three
queries instead of one. Significant exceptions would be if one of the columns
had a very large (in bytes) value so that time was dominated by how long
it took to transmit that value and if you don't expect the needed data
to be available from postgres' or the OS' cache for the first queries.