* Dmitry Sivachenko <[EMAIL PROTECTED]> [010406 05:18] wrote:
> Hello!
>
> What does 'ffsfsn' state (shown in top(1) output) mean?
> I am inserting records in Postgres, and the process is going very slowly
> probably due to postgres is in this state...
Looks like part of the file being fsync'd. Did you read the docs
that come with Postgresql? There's an option you need to use to
disable calls to fsync() for each operation that ought to speed
things up for you.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
Represent yourself, show up at BABUG http://www.babug.org/
To Unsubscribe: send mail to [EMAIL PROTECTED]
with "unsubscribe freebsd-hackers" in the body of the message
