Re: 8.4.1 ubuntu karmic slow createdb
| От | Nikolas Everett |
|---|---|
| Тема | Re: 8.4.1 ubuntu karmic slow createdb |
| Дата | |
| Msg-id | d4e11e980912101738t77b654b2j1db1c023eafd9a58@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: 8.4.1 ubuntu karmic slow createdb (Andres Freund <andres@anarazel.de>) |
| Ответы |
Re: 8.4.1 ubuntu karmic slow createdb
Re: 8.4.1 ubuntu karmic slow createdb |
| Список | pgsql-performance |
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.
On Thu, Dec 10, 2009 at 5:09 PM, Andres Freund <andres@anarazel.de> wrote:
Hi,- Possibly their config is different - they could have disabled the "fsync"
On Thursday 10 December 2009 23:01:08 Michael Clemmons wrote:
> Im not sure what that means ppl in my office with slower hd speeds using
> 8.4 can create a db in 2s vs my 8-12s.
parameter which turns the database to be not crashsafe anymore but much faster
in some circumstances.
- Possibly you have much data in your template1 database?
You could check whether
CREATE DATABASE speedtest TEMPLATE template1; takes more time than
CREATE DATABASE speedtest TEMPLATE template0;.
You should issue both multiple times to ensure caching on the template
database doesnt play a role.Seems unlikely.
> Could using md5 instead of ident do it?
Is starting psql near-instantaneus? Are you using "createdb" or are you
issuing "CREATE DATABASE ..."?
Andres
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
В списке pgsql-performance по дате отправления: