| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Jack Zhu <jzhu(at)netcom-sys(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Emergency questions for new bie |
| Date: | 2000-04-13 02:05:06 |
| Message-ID: | Pine.LNX.4.21.0004130331100.358-100000@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden
| From | Date | Subject | |
|---|---|---|---|
| Next Message | singh parvind | 2000-04-13 02:54:32 | none |
| Previous Message | Jack Zhu | 2000-04-12 20:29:19 | Emergency questions for new bie |