Message-ID: <1130523763.43626c739791d@xxxxxxxxxxxxxxxxxx>
Date: Fri, 28 Oct 2005 13:22:43 -0500 (CDT)
From: davidgn@xxxxxxxxxxxxxxxx
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.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 query I do to the
table returns me 0 rows
Is there any way to ask postgres to update the data more frequently or some way
to make it end sooner?
I am a bit clueless as to what can I do to the configuration files to optimize
this copy.
Thank you
-------------------------------------------------
www.correo.unam.mx
UNAMonos Comunicándonos
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
