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 по дате отправления: