Re: insertion becoming slow

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: insertion becoming slow
Дата
Msg-id 20050929205452.GO30974@pervasive.com
обсуждение исходный текст
Ответ на insertion becoming slow  ("surabhi.ahuja" <surabhi.ahuja@iiitb.ac.in>)
Список pgsql-general
On Tue, Sep 27, 2005 at 03:09:43PM +0530, surabhi.ahuja wrote:
>  is it some logging information that is being written into some file at the end of some transactions
> (each intsall is one transaction for me)
>
> the data directory is containing these folders..
>
> base/    pg_clog/     pg_ident.conf  pg_subtrans/  PG_VERSION  postgresql.conf  postmaster.pid
> global/  pg_hba.conf  pg_log/        pg_tblspc/    pg_xlog/    postmaster.opts
>
> it seems that some info is going into pg_xlog,
> is that taking time ....?

Read up on the WAL:
http://www.postgresql.org/docs/8.0/interactive/wal.html
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

В списке pgsql-general по дате отправления:

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: [SQL] add column if doesn't exist (fwd)
Следующее
От: SCassidy@overlandstorage.com
Дата:
Сообщение: Re: DBI/DBD::Pg mem. use goes exponential