Re: INSERTs slow
От | PGMailList |
---|---|
Тема | Re: INSERTs slow |
Дата | |
Msg-id | 002e01c1d4cc$f4813590$05faa8c0@edios обсуждение исходный текст |
Ответ на | INSERTs slow (Dominique ROUSSEAU <d.rousseau@nnx.com>) |
Список | pgsql-general |
Have you tried dropping and recreating the index. or REINDEX { TABLE | DATABASE | INDEX } name [ FORCE ] Maybe that index of yours is not so kosher http://www.pgexplorer.com ----- Original Message ----- From: "Dominique ROUSSEAU" <d.rousseau@nnx.com> To: <pgsql-general@postgresql.org> Sent: Tuesday, March 26, 2002 3:40 PM Subject: Re: [GENERAL] INSERTs slow > Le Tue, Mar 26, 2002 at 03:30:58PM +0200, PGMailList [pgmail@pgexplorer.com] a écrit: > > 1) Do you have constraints on the index ie Unique or Primary Key? > > they are just : > CREATE INDEX idx1 ON table(field1); > > > 2) Do you have any triggers or rules on the table. > > > > 3) How often do you do a VACUUM ANALYZE > > that's what I started doing, but doesn't change much :/ > once a day > (there are thousands of INSERTs each day) > > Dom > > > ----- 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 > > > > > > 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 > > > > > -- > Dominique Rousseau <d.rousseau@nnx.com> > Neuronnexion - http://www.neuronnexion.com > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >
В списке pgsql-general по дате отправления: