Re: 8.4.1 ubuntu karmic slow createdb
| От | Nikolas Everett |
|---|---|
| Тема | Re: 8.4.1 ubuntu karmic slow createdb |
| Дата | |
| Msg-id | d4e11e980912111243s6b0a67b1u2c2c22031fadf756@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: 8.4.1 ubuntu karmic slow createdb ("Joshua D. Drake" <jd@commandprompt.com>) |
| Ответы |
Re: 8.4.1 ubuntu karmic slow createdb
Re: 8.4.1 ubuntu karmic slow createdb |
| Список | pgsql-performance |
Turning fsync off on a dev database is a bad idea? Sure you might kill it and have to start over, but thats kind of the point in a dev database.
On Fri, Dec 11, 2009 at 12:58 PM, Joshua D. Drake <jd@commandprompt.com> wrote:
On Thu, 2009-12-10 at 20:38 -0500, Nikolas Everett wrote:Do not turn fsync off. That is bad advice. I would not suggest ext4 at
> In my limited experience ext4 as presented by Karmic is not db
> friendly. I had to carve my swap partition into a swap partition and
> an xfs partition to get better db performance. Try fsync=off first,
> but if that doesn't work then try a mini xfs.
this point for database operations. Use ext3. It is backward compatible.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
If the world pushes look it in the eye and GRR. Then push back harder. - Salamander
В списке pgsql-performance по дате отправления: