Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: How to optimize insert statements ?

  • From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
  • To: "Christian Leclerc" <cleclerc(at)ilog(dot)fr>
  • Cc: pgsql-novice(at)postgresql(dot)org
  • Subject: Re: How to optimize insert statements ?
  • Date: Tue, 24 Jul 2007 10:33:29 -0400
  • Message-id: <9177.1185287609@sss.pgh.pa.us> <text/plain>
"Christian Leclerc" <cleclerc(at)ilog(dot)fr> writes:
> I'm encountering a performance issue with insert statements.

It looks to me like your trigger is the entire cause of the slowness.
I think you would be well advised to get rid of it and use a serial
column (ie a sequence object) instead of a handmade, poorly performing
substitute for sequences.

			regards, tom lane
Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group