Re: query is taking longer time after a while

From: tomrevam <tomer(at)fabrix(dot)tv>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: query is taking longer time after a while
Date: 2009-09-30 06:32:45
Message-ID: 25675694.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2009-09-30 06:48:42 Re: query is taking longer time after a while
Previous Message tomrevam 2009-09-30 06:26:54 Re: query is taking longer time after a while