manifoldcf-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Karl Wright <daddy...@gmail.com>
Subject Re: Scaling in MCF
Date Mon, 10 Nov 2014 14:46:05 GMT
Hi Aehem,

Thanks -- this is very helpful.

Can you describe a bit about the hardware details the machine(s) you are
running PostgreSQL on?  Specifically, are the disks SSD's, RAIDs, or what?

Thanks!
Karl


On Mon, Nov 10, 2014 at 9:40 AM, Aeham Abushwashi <
aeham.abushwashi@exonar.com> wrote:

> Hi Karl,
>
> I should be able to help with testing the changes once they're stable
> enough, certainly if they are on a 1.7.x/1.8 branch.
>
> >> Could you come up with an estimate for how long that would in fact
> take?  You mentioned one hour; how many documents was that for?
> Running a query that updates all jobqueue records from priorityset=NULL to
> priorityset=0 took ~65 minutes in my environment. The jobqueue table in
> this instance had ~38M records, of which ~36M had priorityset=NULL.
>
> Aeham
> ‚Äč
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message