Re: query is taking longer time after a while - Mailing list pgsql-general

From tomrevam
Subject Re: query is taking longer time after a while
Date
Msg-id 25675694.post@talk.nabble.com
Whole thread Raw
In response to Re: query is taking longer time after a while  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: query is taking longer time after a while  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general


Scott Marlowe-2 wrote:
>
> Just wondering, what version of pgsql are you running?  I noticed a
> lot less degradation from heavily updated tables when I went to 8.3
> and set the fill % for tables / indexes to 90% or so.  If you're
> running an older version, the upgrade to 8.3 may well be worth the
> effort.
>

I'm using version 8.3, but I don't know what you meant by fill %.

Thanks,
Tomer
--
View this message in context: http://www.nabble.com/query-is-taking-longer-time-after-a-while-tp25661219p25675694.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: tomrevam
Date:
Subject: Re: query is taking longer time after a while
Next
From: "A. Kretschmer"
Date:
Subject: Re: query is taking longer time after a while