Re: Optimizing projections containing unused columns

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: Andrus <kobruleht2(at)hot(dot)ee>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Optimizing projections containing unused columns
Date: 2008-10-16 19:44:35
Message-ID: 2f4958ff0810161244x6e028a53y65d4173d4d2f3d58@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I just generally wanted to show, that even tho it is much smarter from
version to version, it still has this little things. I generally don't put
'is null' or 'is not null' in queries on column that is 'not null' - but it
is imo example of those little things, where postgres isn't so smart yet :)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mikkel Høgh 2008-10-16 21:17:35 Re: Drupal and PostgreSQL - performance issues?
Previous Message Pavel Stehule 2008-10-16 19:37:50 Re: PL/pgSQL stored procedure returning multiple result sets (SELECTs)?