Re: [GENERAL] Performance while loading data and indexing
От | Shridhar Daithankar |
---|---|
Тема | Re: [GENERAL] Performance while loading data and indexing |
Дата | |
Msg-id | 3D936DDB.26585.14990280@localhost обсуждение исходный текст |
Ответ на | Re: [GENERAL] Performance while loading data and indexing (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-hackers |
On 26 Sep 2002 at 10:42, Tom Lane wrote: > Justin Clift <justin@postgresql.org> writes: > > If it's any help, when I was testing recently with WAL on a separate > > drive, the WAL logs were doing more read&writes per second than the main > > data drive. > > ... but way fewer seeks. For anything involving lots of updating > transactions (and certainly 5000 separate insertions per second would > qualify; can those be batched??), it should be a win to put WAL on its > own spindle, just to get locality of access to the WAL. Probably they will be a single transcation. If possible we will bunch more of them together.. like 5 seconds of data pushed down in a single transaction but not sure it's possible.. This is bit like replication but from live oracle machine to postgres, from information I have. So there should be some chance of tuning there.. Bye Shridhar -- Langsam's Laws: (1) Everything depends. (2) Nothing is always. (3) Everything is sometimes.
В списке pgsql-hackers по дате отправления: