Re: [GENERAL] querying while copying into a table and optimizations

2005-10-30 Thread David Eduardo Gómez Noguera
On Sat, 2005-10-29 at 09:10 -0600, Michael Fuhr wrote: > On Fri, Oct 28, 2005 at 06:22:43PM -, [EMAIL PROTECTED] wrote: > > This is postgresql 7.4 > > I am trying to check that postgres is updating a table. > > I have a pretty large ascii table file (+- 210 Mb) which I am copying into > > a >

Re: [GENERAL] querying while copying into a table and optimizations

2005-10-29 Thread Michael Fuhr
On Fri, Oct 28, 2005 at 06:22:43PM -, [EMAIL PROTECTED] wrote: > This is postgresql 7.4 > I am trying to check that postgres is updating a table. > I have a pretty large ascii table file (+- 210 Mb) which I am copying into a > table with pgsql, but it is taking a long time, and any select quer

[GENERAL] querying while copying into a table and optimizations

2005-10-28 Thread davidgn
Message-ID: <[EMAIL PROTECTED]> Date: Fri, 28 Oct 2005 13:22:43 -0500 (CDT) From: [EMAIL PROTECTED] MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: IMP/PHP IMAP webmail program 2.2.8 X-Originating-IP: 200.34.166.34 Hi This is postgresql 7.