Re: Maximum Possible Insert Performance?

William Yu <wyu@talisys.com> writes:
> I then tried to put the WAL directory onto a ramdisk. I turned off 
> swapping, created a tmpfs mount point and copied the pg_xlog directory 
> over. Everything looked fine as far as I could tell but Postgres just 
> panic'd with a "file permissions" error. Anybody have thoughts to why 
> tmpfs would not work?

I'd say you got the file or directory ownership or permissions wrong.

			regards, tom lane