Hi
I’m trying to move an existing solution from MySQL
to PostgreSQL. As it is now the solution has 4 tables where data in inserted by
an application. At regular intervals (10min) data from these tables is
consolidated and moved to another table for reporting purposes. There exist
many i
Hi all
I'm wondering if and how the size of a table affects speed of inserts
into it? What if the table has indexes, does that alter the answer?
Thanks
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
ize
of the table play a role in determining insert performance (and I mean
only insert performance)?
-Original Message-
From: Jacques Caron [mailto:[EMAIL PROTECTED]
Sent: 27 June 2005 13:40
To: Praveen Raja
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Insert performance vs Tabl
ailto:[EMAIL PROTECTED]
Sent: 27 June 2005 14:05
To: Praveen Raja
Cc: pgsql-performance@postgresql.org
Subject: RE: [PERFORM] Insert performance vs Table size
Hi,
At 13:50 27/06/2005, Praveen Raja wrote:
>Just to clear things up a bit, the scenario that I'm interested in is a
>table wit
