> > How were you inserting the data? Were you doing multiple inserts per
> > transactions? Copy? That sounds really slow to me.
>
> The database mainly contains integers, which represent the behavior of
> internet users on our site, so it's very compact data.
> We used multiple insert with my
Message -
From: "Ferdinand Smit" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 30, 2002 6:42 AM
Subject: Re: [ADMIN] INSERT performace.
> Hi,
>
> > > > > > We have a fresh database and have begun to observe performance
> >
Hi,
> > > > > We have a fresh database and have begun to observe performance
> > > > > degradation for INSERTs as a table went from empty to
> > > > > 100,000-ish rows. Initial INSERTs were sub second while after
> > > > > 30k rows, they were 1-3 seconds.
> > > >
> > > > we just hit this problem
> > > > We have a fresh database and have begun to observe performance
> > > > degradation for INSERTs as a table went from empty to
> > > > 100,000-ish rows. Initial INSERTs were sub second while after
> > > > 30k rows, they were 1-3 seconds.
> > >
> > > we just hit this problem when moving old
On Sunday 27 January 2002 20:31, Sean Chittenden wrote:
> > > We have a fresh database and have begun to observe performance
> > > degradation for INSERTs as a table went from empty to 100,000-ish
> > > rows. Initial INSERTs were sub second while after 30k rows, they
> > > were 1-3 seconds.
> >
>
> > We have a fresh database and have begun to observe performance
> > degradation for INSERTs as a table went from empty to 100,000-ish
> > rows. Initial INSERTs were sub second while after 30k rows, they
> > were 1-3 seconds.
>
> we just hit this problem when moving old database to new one (ne
On Sat, Jan 26, 2002 at 08:10:19PM -0600, Marc Mitchell wrote:
> We have a fresh database and have begun to observe performance degradation
> for INSERTs as a table went from empty to 100,000-ish rows. Initial
> INSERTs were sub second while after 30k rows, they were 1-3 seconds.
we just hit thi
- Original Message -
From: "Bruce Momjian" <[EMAIL PROTECTED]>
To: "Marc Mitchell" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, January 26, 2002 10:51 PM
Subject: Re: [ADMIN] INSERT performace.
> Marc Mitchell wrote:
> > We
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Marc Mitchell" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, January 26, 2002 11:06 PM
Subject: Re: [ADMIN] INSERT performace.
> "Marc Mitchell" <[EMAIL PRO
"Marc Mitchell" <[EMAIL PROTECTED]> writes:
> We have a fresh database and have begun to observe performance degradation
> for INSERTs as a table went from empty to 100,000-ish rows. Initial
> INSERTs were sub second while after 30k rows, they were 1-3 seconds.
> Note that we have done NO perfor
Marc Mitchell wrote:
> We have a fresh database and have begun to observe performance degradation
> for INSERTs as a table went from empty to 100,000-ish rows. Initial
> INSERTs were sub second while after 30k rows, they were 1-3 seconds.
>
> Note that we have done NO performance tuning yet nor
We have a fresh database and have begun to observe performance degradation
for INSERTs as a table went from empty to 100,000-ish rows. Initial
INSERTs were sub second while after 30k rows, they were 1-3 seconds.
Note that we have done NO performance tuning yet nor are there any indexes
on the ta
12 matches
Mail list logo
