lai yoke hman wrote: > How can I know my PostgreSQL 8 is using direct I/O or buffered I/O? If > using buffered I/O, how can I enable direct I/O? What is the > performance difference of them?
1. it is buffered 2. you can't 3. there isn't any because there isn't direct I/O Unless you mess with the filesystem features, at which point I shut up or they shut me down. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings