On Feb 28, 2008, at 1:58 PM, Alan Hodgson wrote:
On Thursday 28 February 2008, Erik Jones <erik@xxxxxxxxxx> wrote:
Or, even simpler:
SELECT pg_switch_xlog();
The original poster is using 8.1.
Ah, I didn't realize that was only available in >= 8.2, thanks for
the clarification.
Erik Jones
DBA | Emma®
erik@xxxxxxxxxx
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
---------------------------(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
