Re: full table...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Felson <felson123(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: full table...
Date: 2002-08-20 02:53:09
Message-ID: 2284.1029811989@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Felson <felson123(at)yahoo(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2002-08-20 03:29:10 Part 2 of Joy of Index up
Previous Message Felson 2002-08-19 23:56:53 full table...