Re: INSERTs slow
От | PGMailList |
---|---|
Тема | Re: INSERTs slow |
Дата | |
Msg-id | 001801c1d4ca$771cc120$05faa8c0@edios обсуждение исходный текст |
Ответ на | INSERTs slow (Dominique ROUSSEAU <d.rousseau@nnx.com>) |
Ответы |
Re: INSERTs slow
|
Список | 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.rousseau@nnx.com> To: <pgsql-general@postgresql.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.rousseau@nnx.com> > Neuronnexion - http://www.neuronnexion.com > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org >
В списке pgsql-general по дате отправления: