Re: Emergency questions for new bie

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