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