Re: Welcom & a problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Együd Csaba <csegyud(at)freemail(dot)hu>
Cc: pginfo <pginfo(at)t1(dot)unisoftbg(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Welcom & a problem
Date: 2002-11-17 18:09:13
Message-ID: 882.1037556553@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?iso-8859-1?Q?Egy=FCd_Csaba?= <csegyud(at)freemail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Patrick Welche 2002-11-17 18:09:39 Re: running query
Previous Message Együd Csaba 2002-11-17 13:27:18 Re: Welcom & a problem