Re: Postgresql tuning.. - Mailing list pgsql-general

From jerome
Subject Re: Postgresql tuning..
Date
Msg-id 200208290815.g7T8F2U44548@gmanewmedia.com
Whole thread Raw
In response to Re: Postgresql tuning..  (dima <_pppp@mail.ru>)
List 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

pgsql-general by date:

Previous
From: Michał Kalański
Date:
Subject: Fw: psql 7.2.1 on S/390
Next
From: "Nikhil G. Daddikar"
Date:
Subject: Deleting foreign key constraints