Re: Optimizing projections containing unused columns - Mailing list pgsql-general

From Andrus
Subject Re: Optimizing projections containing unused columns
Date
Msg-id 9DD2E011713C4190910C04D534571178@andrusnotebook
Whole thread Raw
In response to Re: Optimizing projections containing unused columns  ("Grzegorz Jaśkiewicz" <gryzman@gmail.com>)
Responses Re: Optimizing projections containing unused columns  ("Andrus" <kobruleht2@hot.ee>)
List pgsql-general
> gj=# explain select count(*) from smartarse where v is null;
>----------------------------------------------------------------
> Aggregate  (cost=21.62..21.63 rows=1 width=0)
<   ->  Seq Scan on smartarse  (cost=0.00..21.60 rows=6 width=0)

Thread question and sample was about using nested queries.
Your sample does not use nested queries but it shows (width=0) that all
columns are excluded.

So I do'nt understand how this applies to topic.

Andrus.


pgsql-general by date:

Previous
From: "Grzegorz Jaśkiewicz"
Date:
Subject: Re: Optimizing projections containing unused columns
Next
From: "Andrus"
Date:
Subject: Re: Optimizing projections containing unused columns