On Tue, 22 Feb 2005, Chris White (cjwhite) wrote:
CWc> We are noticing on our 7.4.5 system the following files are being written
CWc> approximately every 5 minutes
CWc>
CWc> /tmp/.s.PGSQL.5432
CWc> /tmp/.s.PGSQL.5432.lock
CWc>
CWc> Anybody know why they are being written? The reason I ask is because we are
CWc> running on a system that uses a laptop disk drive and requires at least 10
CWc> minutes idle time to spindown so it can recalibrate. This did not happen
CWc> when we were running 7.4.2, so does anybody have any idea what may have
CWc> changed between 7.4.2 and 7.4.5 to cause this to happen.
What about switching to memory-based /tmp ?
Sincerely,
D.Marck [DM5020, MCK-RIPE, DM3-RIPN]
------------------------------------------------------------------------
*** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- [EMAIL PROTECTED] ***
------------------------------------------------------------------------
---------------------------(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
