From: | Robert Schnabel <schnabelr(at)missouri(dot)edu> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | WAL and TMP directory locations |
Date: | 2009-04-02 16:13:59 |
Message-ID: | 49D4E447.5060007@missouri.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I suspect that I already know the answer to my question but I'm looking
for confirmation from experts. I have moved my pg_xlog and pgsql_tmp
directories to a separate disk array to distribute IO. Some details...
Windows XP64, pg 8.3.7, all disk arrays are direct attach to my raid
card (SAS).
I have one rather large table (~1.5 B rows) that I do sorting and
grouping on in order to calculate some values that I need and then
insert those values into another table. This produces a lot of tmp
files (over 80 the last time I ran the query) which is why I moved the
tmp directory.
Question... is this appropriate and is there anything else I could
change to help speed things up.
Thanks,
Bob
From | Date | Subject | |
---|---|---|---|
Next Message | Mary Anderson | 2009-04-03 00:38:35 | constraint is not dropped when table is dropped (maybe php related???) |
Previous Message | Larry Rosenman | 2009-04-01 20:05:27 | Re: grouping by time interval |