> I'm using Postges to log certain customer activities on our web site -
> logins, things like that. I vacuum once a night. Now the database has
> grown quite large, the main table alone is 180 Mb. It contains lots and
> lots of small rows.
>
That is a very small database. :)
> Anyway, a few minutes ago I ran a single query. After it finished, I
> noticed that the CPU usage had dropped dramatically. Like from a load
> average of about 5 to about 0.8. Now I'm wondering if the query I ran
> was the cause of this. Will postgres slow down if the only operations
> being performed are inserts?
>
What indexes do you have on the table? Having lots of indexes could slow
down inserts, but speed up queries. If you don't have any indexes, a
query against a 180 meg table could take a while, particularly if you
have less then 180 megs of ram.
jesse
