Re: Emergency questions for new bie - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: Emergency questions for new bie
Date
Msg-id Pine.LNX.4.21.0004130331100.358-100000@localhost.localdomain
Whole thread Raw
In response to Emergency questions for new bie  (Jack Zhu <jzhu@netcom-sys.com>)
List pgsql-admin
Jack Zhu writes:

> 1.How can I enable PG run as 'no-fsync' mode to improve performance?

postmaster -o '-F'

> How can I check PG is in 'fsync' mode or not?

It is if and only if you give the above option.

> But when I tried to create an index on this 'timestamp' column, I got
> this error and creating failed: 'Cannot find a default operator class
> for type 1296.'

Indexes don't work for timestamp in 6.5. Use datetime, or better yet
upgrade to 7.0 which should be out in a few weeks. (jinx)


--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden


pgsql-admin by date:

Previous
From: Jack Zhu
Date:
Subject: Emergency questions for new bie
Next
From: James Blackwell
Date:
Subject: Re: Need some shmget advice