It's a bit strange, because none of the processes on the server has a
very high value in ANY of the memory related columns in Task Manager.

So, who's consuming this vast amount of memry? File system cache? How
can I see?

The fb_inet_server process for the update query has million of I/O
reads, of course, but the count of page faults stands still.

Perhaps I should increase the page buffer to let FB cache more and do
less disk I/O? But would that stop the filesystem from using up all the
RAM for caching? Is this even a problem?

Kjell

Kjell Rilbe skriver:

>
>
> Oh, I forgot to say it's Firebird 2.1 64 bit. Would it help to upgrade
> to 2.5?
>
> Kjell
>
> Kjell Rilbe skriver:
> > Hi,
> >
> > I've got a classic server on a 8 cpu Windows 64 bit server with 8
> Gbyte RAM.
> >
> > I'm currently doing an update on a table with 70 million records, with a
> > subquery searching with a similar record count. It's taking a long time,
> > as expected considering the record counts, but I'm wondering about
> > memory usage. It's hit the roof and is probably swapping like crazy.
> >
> > firebird.conf has defaults on all settings except some paths
> > (DatabaseAccess, ExternalFileAccess, UdfAccess).
> >
> > The database has page size 4096 or 8192 (not quite sure, it should be
> > 8192 but we may have forgot to set it...).
> >
> > There's only this one connection that's actually doing anything.
> >
> > The query:
> > update "Items"
> > set "RemovingUpdate" = (
> > select "Update"
> > from "ItemRemovalEvents"
> > where "ItemRemovalsEvents"."Id" = "Items"."RemovingEvent"
> > )
> > where "RemovingEvent" is not null
> >
> > The plan:
> > PLAN("ItemRemovalEvents" INDEX (IX_PK_ItemRemovalEvents))
> > PLAN("Items" NATURAL)
> >
> > I assume it's doing a natural scan on the target table and indexed
> > lookups on the subquery table. This is fine, isn't it? No reason to try
> > to get it to use a better plan?
> >
> > Regards,
> > Kjell
>
> --
> ------------------------------
> Kjell Rilbe
> DataDIA AB
> E-post: kjell.rilbe@... <mailto:kjell.rilbe%40datadia.se>
> Telefon: 08-761 06 55
> Mobil: 0733-44 24 64
>
> [Non-text portions of this message have been removed]
>
>

--
------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64



[Non-text portions of this message have been removed]