| From: | Jozef Ševčík <sevcik(at)styxsystems(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Quoting table/column names vs performance |
| Date: | 2008-04-09 15:27:42 |
| Message-ID: | D2C6AB7E6EDFD94788D27D1F537FCC3806176F63EC@VMBX102.ihostexchange.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi all,
I just switched from MS SQL to PostgreSQL on project and have question about double-quoting names of fields/tables
regarding to performance.
In MSSQL I had something like:
SELECT Column1,Column2 from MyTable
In PgSQL I write:
SELECT "Column1", "Column2" from "MyTable"
Which is fine and working, I have no doubt about it. I'm just guessing if this does not affect performance
in any way.
I know I may rename tables/fields to lowercase and avoid double-quotting, but it double-quotting has no
affect on perf. is it worth it ?
Or are there any advantages of using 'non-quoted' identifiers agains double-quoted ?
Thanks
S pozdravom / Best regards,
Jozef Ševčík
sevcik(at)styxsystems(dot)com<mailto:sevcik(at)styxsystems(dot)com>
+420 608 782 813
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martin Gainty | 2008-04-09 15:32:18 | Re: Problem with windows Postgres 8.3.1 MSI binary distribution |
| Previous Message | Peter Geoghegan | 2008-04-09 15:20:26 | Re: Problem with windows Postgres 8.3.1 MSI binary distribution |