Re: Welcom & a problem - Mailing list pgsql-general

From Tom Lane
Subject Re: Welcom & a problem
Date
Msg-id 882.1037556553@sss.pgh.pa.us
Whole thread Raw
In response to Re: Welcom & a problem  (Együd Csaba <csegyud@freemail.hu>)
List pgsql-general
=?iso-8859-1?Q?Egy=FCd_Csaba?= <csegyud@freemail.hu> writes:
> I also use a few indexes on the tables and they have to be updated 180 times
> every minute. Could it be too huge a load for the server?

No ... but I wonder whether this database is getting vacuumed regularly?

Depending on your data patterns, it might also be that you need to
reindex every so often.

Also, what PG version is this?

            regards, tom lane

pgsql-general by date:

Previous
From: Együd Csaba
Date:
Subject: Re: Welcom & a problem
Next
From: Patrick Welche
Date:
Subject: Re: running query