Slavisa Garic <[EMAIL PROTECTED]> writes:
> You didn't understand the question. Inserting ONE ROW when there are already
> 5000 ROWS present takes 0.01 seconds. Inserting ONE ROW when there are
> already 6 ROWS present takes 0.09 secods.
The numbers you presented didn't really offer any strong
> -Original Message-
> From: Slavisa Garic [mailto:[EMAIL PROTECTED]
> Sent: Friday, November 14, 2003 5:12 PM
> To: Dann Corbit
> Cc: Slavisa Garic; [EMAIL PROTECTED]
> Subject: Re: [HACKERS] INSERT extremely slow with large data sets
>
>
> Hi Dann
>
Similar
behaviour is observed but it just takes a bit less time to insert (0.01
less then usually at 6 records)
Regards,
Slavisa
On Fri, 14 Nov 2003, Dann Corbit
wrote:
> > -Original Message-
> > From: Slavisa Garic [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, November
On Fri, 14 Nov 2003, Alvaro Herrera wrote:
> On Fri, Nov 14, 2003 at 06:36:41PM +1100, Slavisa Garic wrote:
>
> > Rows PresentStart Time Finish Time
> >
> > 100 1068790804.12 1068
> -Original Message-
> From: Slavisa Garic [mailto:[EMAIL PROTECTED]
> Sent: Thursday, November 13, 2003 11:37 PM
> To: [EMAIL PROTECTED]
> Subject: [HACKERS] INSERT extremely slow with large data sets
>
>
> Hi Everyone,
>
> This is my first post here so
On Fri, Nov 14, 2003 at 06:36:41PM +1100, Slavisa Garic wrote:
> Rows Present Start Time Finish Time
>
> 100 1068790804.12 1068790804.12
> 1000 1068790807.87 10
Hi Everyone,
This is my first post here so please tell me to go somewhere else if this
is the wrong place to post questions like this.
I am using PostgreSQL 7.3.2 and have used earlier versions (7.1.x onwards)
and with all of them I noticed same problem with INSERTs when there is a
large data set
There is a pgsql-performance list, which was created for questions like yours.
Your problem was brought up many times before, so searching the archives is
an alternative.
Regards, Christoph
>
> Hi Everyone,
>
> This is my first post here so please tell me to go somewhere else if this
> is
Hi Everyone,
This is my first post here so please tell me to go somewhere else if this
is the wrong place to post questions like this.
I am using PostgreSQL 7.3.2 and have used earlier versions (7.1.x onwards)
and with all of them I noticed same problem with INSERTs when there is a
large data
