On Wed, 2005-09-14 at 21:06, John Fabiani wrote:
> On Wednesday 14 September 2005 08:23, Scott Marlowe wrote:
>
> > OK. But how many are you updating between regular vacuums? That's the
> > real issue. If your regular vacuums aren't often enough, postgresql
> > starts lengthening the tables ins
On Wednesday 14 September 2005 08:23, Scott Marlowe wrote:
> OK. But how many are you updating between regular vacuums? That's the
> real issue. If your regular vacuums aren't often enough, postgresql
> starts lengthening the tables instead of reusing the space in them that
> was freed by the l
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Scott Marlowe
> Sent: Wednesday, September 14, 2005 8:24 AM
> To: Warren Bell
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Speed problems
>
>
> On Tue, 20
On Tue, 2005-09-13 at 21:01, Warren Bell wrote:
> >On Tue, 2005-09-13 at 13:20, Warren Bell wrote:
> >> I am having problems with performance. I think this is a simple question
> and
> >> I am in the right place, if not, please redirect me.
> >>
> >> I have a table with 36 fields that slows down qu
>On Tue, 2005-09-13 at 13:20, Warren Bell wrote:
>> I am having problems with performance. I think this is a simple question
and
>> I am in the right place, if not, please redirect me.
>>
>> I have a table with 36 fields that slows down quite a bit after some
light
>> use. There are only 5 clients
When you say VACUUM do you really mean VACUUM ANALYZE? Have you tried a
simple ANALYZE?
I'm assuming of course that you have indexes that you want to use
Warren Bell wrote:
I am having problems with performance. I think this is a simple question and
I am in the right place, if not, pl
On Tue, 2005-09-13 at 13:20, Warren Bell wrote:
> I am having problems with performance. I think this is a simple question and
> I am in the right place, if not, please redirect me.
>
> I have a table with 36 fields that slows down quite a bit after some light
> use. There are only 5 clients conne
"Warren Bell" <[EMAIL PROTECTED]> writes:
> I have a table with 36 fields that slows down quite a bit after some light
> use. There are only 5 clients connected to this DB and they are doing mostly
> inserts and updates. There is no load on this server or db at all. This
> table has had no more tha
I am having problems with performance. I think this is a simple question and
I am in the right place, if not, please redirect me.
I have a table with 36 fields that slows down quite a bit after some light
use. There are only 5 clients connected to this DB and they are doing mostly
inserts and upda
