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

Re: INSERTs slow

From: "PGMailList" <pgmail(at)pgexplorer(dot)com>
To: "Dominique ROUSSEAU" <d(dot)rousseau(at)nnx(dot)com>,<pgsql-general(at)postgresql(dot)org>
Subject: Re: INSERTs slow
Date: 2002-03-26 13:30:58
Message-ID: 001801c1d4ca$771cc120$05faa8c0@edios (view raw or flat)
Thread:
Lists: pgsql-general
1) Do you have constraints on the index ie Unique or Primary Key? 

2) Do you have any triggers or rules on the table. 

3) How often do you do a VACUUM ANALYZE 

All these will influence the speed 



http://www.pgexplorer.com

GUI Frontend for PostgreSQL

----- Original Message ----- 

From: "Dominique ROUSSEAU" <d(dot)rousseau(at)nnx(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, March 26, 2002 11:07 AM
Subject: [GENERAL] INSERTs slow


> Hi,
> 
> 
> I have a table with around 1.5 millions entries, and INSERTs are very
> slowwwww.
> This table has 3 indices on "char(32)" fields.
> 
> Without indices, the INSERTs are fluent, with indices, it crawls :/
> 
> Any idea ?
> 
> As a sidenote, it was going rather well when the table contained only 1
> million entries.
> 
> Dom
> 
> -- 
> Dominique Rousseau <d(dot)rousseau(at)nnx(dot)com>          
> Neuronnexion - http://www.neuronnexion.com            
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org
> 


In response to

  • INSERTs slow at 2002-03-26 09:07:30 from Dominique ROUSSEAU

Responses

pgsql-general by date

Next:From: Dominique ROUSSEAUDate: 2002-03-26 13:40:30
Subject: Re: INSERTs slow
Previous:From: Arsalan ZaidiDate: 2002-03-26 12:22:12
Subject: Speed diff cause by multi-byte support

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group