Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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
"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
- Follow-Ups:
- Re: How to optimize insert statements ?
- From: Christian Leclerc
- Re: How to optimize insert statements ?
- References:
- How to optimize insert statements ?
- From: Christian Leclerc
- How to optimize insert statements ?
- Prev by Date: How to optimize insert statements ?
- Next by Date: DEFERABLE vs. NOT DEFERABLE constraints
- Previous by thread: How to optimize insert statements ?
- Next by thread: Re: How to optimize insert statements ?
- Indexes: