Quoting table/column names vs performance

[Jozef Ševčík <sevcik@xxxxxxxxxxxxxxx>]

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@xxxxxxxxxxxxxxx

+420 608 782 813