| From: | jerome <jerome(at)gmanmi(dot)tv> |
|---|---|
| To: | dima <_pppp(at)mail(dot)ru> |
| Cc: | PostgresGeneral <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Postgresql tuning.. |
| Date: | 2002-08-29 08:34:14 |
| Message-ID: | 200208290815.g7T8F2U44548@gmanewmedia.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
would it make a difference if ill be using an 12 digit primary key compared
to a 12 chars primary keyed table....
difference in terms of speed/performance from a select and update queries...
TIA
On Thursday 29 August 2002 03:30, you wrote:
> > what would be faster on SELECT and UPDATE query...
> > a table with a varchar as a primary key or an int primary keyed column..
>
> varchar primary keys are always slower
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nikhil G. Daddikar | 2002-08-29 09:15:27 | Deleting foreign key constraints |
| Previous Message | Andrew | 2002-08-29 08:23:05 | to_char(0,'FM999.99') outputs 0. |