Re: pg_ctl vs. Windows locking
Andrew Dunstan <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.devel.win32 |
|---|---|
| Message-ID | <[email protected]> |
Tom Lane wrote: >Andrew Dunstan <[email protected]> writes: > > >>When I was watching it in the Task Manager, it was observable that the >>postmaster exited before some of the other backend processes, by up to a >>second or two. >> >> > >The stats collector processes normally don't shut down until they >observe postmaster exit (and I think in CVS tip there's an >up-to-one-second delay before they'll even look). Everything else >should be gone first though. > > > I assumed it was them. Can't tell in Task Manager, that I can see - all you get is the image name :-( Sounds like a 2 second sleep should do the trick. Will test later. Maybe we should do it everywhere, not just Windows, to ensure that we don't get nasty interleaving on the log file? cheers andrew ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match