Postgres Pro
Downloads
Home   >   mailing lists

select/update performance? - Mailing list pgsql-general

From Bjørn T Johansen
Subject select/update performance?
Date
Msg-id 1068024291.12114.16.camel@pgsqlsrv.havleik.no
Whole thread Raw
Responses Re: select/update performance?
List pgsql-general
Tree view 
I need to maintain a manually counter for an id-field, but I can do this
two ways. Either make a counter table (which means one select and one
update) or just selecting the largest id from existing table and
increment by one (just one select + one table lock). Which one is
fastest?


Regards,

BTJ

pgsql-general by date:

Previous
From: "Jaime Casanova"
Date:
Subject: Re: Database design question: ugliness or referential integrity?
Next
From: Manfred Koizar
Date:
Subject: Re: Help on update that subselects other records in table, uses joins