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@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
