Yes - processmon always shows the files being locked by postgres.exe
processes. My database is being used as a data warehouse, so about all
I am doing is bulk insert/updates. I have a job that runs every 5
minutes and loads data into the database.
I typically load between 10,000 and 100,000 rows every 5 minutes into my
fact tables, although I also make use of transition tables, dimension
tables, etc. that get inserts/updates as well. I see the problem occur
3-4 times a day on average, but I don't know how to reproduce it other
than letting it run for a while.
On Tue, 28 Nov 2006 22:31:42 +0100, "Thomas H." <me@alternize.com> said:
> >I forgot to mention - this problem is occurring on multiple Windows
> > machines. One of them is running Windows XP Professional. The other is
> > running Windows Server 2003. I have disabled indexing, virus scanning,
> > and all non-essential services on both of them. The problem continues
> > to show up even when no queries are being run (although it might always
> > start while queries are running)
>
> seems exactly what i'm noticing since 8.2x on windows 2003 as well - no
> disk
> services (backup, virus, ...) are running that would block files, and
> processmon/filemon always show that the files in question are locked by
> pgsql processes...
>
> under higher insert/update load, the errors appear more often here, do
> you
> experience the same finding when loading bulk data?
>
> - thomas
>
>