Re: full table... - Mailing list pgsql-novice

From Tom Lane
Subject Re: full table...
Date
Msg-id 2284.1029811989@sss.pgh.pa.us
Whole thread Raw
In response to full table...  (Felson <felson123@yahoo.com>)
Responses Re: full table...
List pgsql-novice
Felson <felson123@yahoo.com> writes:
> I have a table that stores a HUGE volume of data every
> day. I am now running into a problem where when I try
> to insert data, the remote connection times out
> because it takes to long... (1 minute)

How much is HUGE?  I'm having a really hard time believing that a simple
insert could take > 1min regardless of table size ... are there perhaps
triggers or rules or foreign-key references on this table that could be
eating the time?

            regards, tom lane

pgsql-novice by date:

Previous
From: Felson
Date:
Subject: full table...
Next
From: Josh Berkus
Date:
Subject: Part 2 of Joy of Index up