Re: Order of columns in query is important?!

From: "Colin 't Hart" <colin(at)sharpheart(dot)org>
To: PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Order of columns in query is important?!
Date: 2015-05-25 09:32:04
Message-ID: CAMon-aQtH2Ggf_8M18v0jT-FwHtHjQQCCbdU1Rj1JLfnyGEHSQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

PS

I should have mentioned that it wasn't me that discovered this but
"Evgeny" on dba.stackexchange
He was reporting a much greater disparity in times.
See http://dba.stackexchange.com/questions/102403/why-is-select-much-faster-than-selecting-all-columns-by-name

Thanks,

Colin

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Langote 2015-05-25 09:38:51 Update README.tuplock?
Previous Message Guillaume Lelarge 2015-05-25 09:30:35 Re: Strange replication problem - segment restored from archive but still requested from master