Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: How to optimize insert statements ?
- From: "Christian Leclerc" <cleclerc(at)ilog(dot)fr>
- To: "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- Cc: <pgsql-novice(at)postgresql(dot)org>
- Subject: Re: How to optimize insert statements ?
- Date: Wed, 25 Jul 2007 19:40:14 +0200
- Message-id: <1F31510056BF344C8D1076017C1367FA0FCF7E@parmbx02.ilog.biz> <text/plain>
Thank you. I just brought the modifications to my code. Using the sequences totally solves my issue. The insertion time is constant and systematically between 15ms and 33ms. Christian
- References:
- How to optimize insert statements ?
- From: Christian Leclerc
- Re: How to optimize insert statements ?
- From: Tom Lane
- Re: How to optimize insert statements ?
- From: Christian Leclerc
- Re: How to optimize insert statements ?
- From: Sean Davis
- How to optimize insert statements ?
- Prev by Date: Re: How to optimize insert statements ?
- Next by Date: tsearch2.sql and different versions of PostgreSQL
- Previous by thread: Re: How to optimize insert statements ?
- Next by thread: DEFERABLE vs. NOT DEFERABLE constraints
- Indexes: