Обсуждение: insertion becoming slow
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
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 ....?
thanks
regards
Surabhi Ahuja
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