<div>
Have you vacuumed your database recently?<br />
eg<br />
<br />
su - postgres <br />
psql prod<br />
\q<br />
vacuumdb prod<br />
<br />
have you any superfluous indexes on this table ?
</div>


Have you vacuumed your database recently?
eg

su - postgres
psql prod
\q
vacuumdb prod

have you any superfluous indexes on this table ?

<div>
Syntax is<br />
<br />
REINDEX { DATABASE | TABLE | INDEX } name [ FORCE ]
</div>


Syntax is

REINDEX { DATABASE | TABLE | INDEX } name [ FORCE ]

<div>
If your database must remain live then dropping and recreating the indexes may be better option than using REINDEX command. &nbsp;REINDEX command creates a table lock, see &nbsp;documentation.
</div>


If your database must remain live then dropping and recreating the indexes may be better option than using REINDEX command.  REINDEX command creates a table lock, see  documentation.

<div>
<div class="content wysiwyg-content">
I am currently using postgresql 7.3.4 with a postfix/amavis/spamassassi<wbr />n mail filter. I've had a lot of performance problems..right now, the whole thing seems to be running fine, except when it comes to INSERT queries. It takes pgsql aproximatively 25 seconds to insert ONE row!! The query itself is &quot;INSERT INTO table (field1,field2,field3) VALUES (?,?,?), and that particular table contains 1,628,525 rows. Does anyone have a clue on how i can optimize this?
</div>
</div>


I am currently using postgresql 7.3.4 with a postfix/amavis/spamassassin mail filter. I've had a lot of performance problems..right now, the whole thing seems to be running fine, except when it comes to INSERT queries. It takes pgsql aproximatively 25 seconds to insert ONE row!! The query itself is "INSERT INTO table (field1,field2,field3) VALUES (?,?,?), and that particular table contains 1,628,525 rows. Does anyone have a clue on how i can optimize this?

Optimizing Postgresql insert

PostgreSQL is an object-relational database management system with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications. PostgreSQL implements the majority of the SQL2011 standard, is ACID-compliant and transactional using multiversion concurrency control (MVCC), and handles complex SQL queries using many indexing methods that are not available in other databases. It is cross-platform and runs on many operating systems including Linux, FreeBSD, OS X, Solaris, and Microsoft Windows.