| Lists: | pgsql-performance |
|---|
| From: | "Whatever Deep" <whatever(dot)deep(at)gmail(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | "MixedCase sensitive quoted" names |
| Date: | 2007-11-03 23:40:42 |
| Message-ID: | 4438f1690711031640t759aa734i25dc5b9ff7979e33@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-performance |
Hello,
This question may sound dumb, but I would like to know if using
"MixedCase sensitive quoted" names instead of lowercase names for
object names has any negative hit to the database performance.
Thanks!
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Whatever Deep" <whatever(dot)deep(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: "MixedCase sensitive quoted" names |
| Date: | 2007-11-04 01:45:37 |
| Message-ID: | 3369.1194140737@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-performance |
"Whatever Deep" <whatever(dot)deep(at)gmail(dot)com> writes:
> This question may sound dumb, but I would like to know if using
> "MixedCase sensitive quoted" names instead of lowercase names for
> object names has any negative hit to the database performance.
I can't imagine you could measure any performance difference ...
the two cases involve slightly different code paths in scan.l,
but after that it doesn't matter.
regards, tom lane