insertion becoming slow

From: "surabhi(dot)ahuja" <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in>
To: <pgsql-general(at)postgresql(dot)org>
Subject: insertion becoming slow
Date: 2005-09-27 09:39:43
Message-ID: 967CFC4343BF2A4DAFACD026D33DC85118EC76@jal.iiitb.ac.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ....?

thanks
regards
Surabhi Ahuja

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gábor Farkas 2005-09-27 09:58:42 Re: change db encoding?
Previous Message Peter Eisentraut 2005-09-27 09:22:37 Re: change db encoding?