Devrim GUNDUZ <[EMAIL PROTECTED]> writes:
> See : https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=152931
> I've increased the sleep time from 1 to 2 for PGDG 8.1 beta RPMs. Let's
> see what will happen in next beta.
I've been using 2 in Red Hat's RPMs for some time. The whole thing is
pretty mystifying though, because there's no way it should take any
significant amount of time for the postmaster to get to the point of
writing its pid-file. It doesn't really do anything except parse its
command-line arguments and the postgresql.conf file before it does that.
I've certainly never been able to reproduce the problem.
It'd be useful to try running the "su" command that launches the
postmaster under "strace -f -tt" to try to gather some information
about why it's so slow. It might be the su rather than the postmaster
per se that's at fault?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
