sequence overhead

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: sequence overhead
Date: 2003-12-03 22:32:18
Message-ID: 1070490739.25244.10530.camel@camel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Just wondering if anyone has done any testing on the amount of overhead
for insert you might gain by adding a serial column to a table. I'm
thinking of adding a few to some tables that get an average of 30 - 40
inserts per second, sometimes bursting over 100 inserts per second and
wondering if there will be any noticeable impact.

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

Browse pgsql-performance by date

  From Date Subject
Next Message Fred Moyer 2003-12-03 22:35:45 Re: Has anyone run on the new G5 yet
Previous Message Eric Soroos 2003-12-03 22:12:08 Re: Has anyone run on the new G5 yet