From: 李江华 <ljh1469@alibaba-inc.com>
To: Praveen Raja <praveen.raja@netlight.se>
To: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Insert performance vs Table size
Date: Mon, 27 Jun 2005 19:30:50 +0800
Message-ID: <20050627113053.6F2E466C097@smtp-hz> (raw)
Praveen Raja:
I think the size of a table don't affect the speed of inserts into it.Because PostgreSQL just doing something like "append" on the data files.
But the index do speed-down the inserts. Because PostgreSQL should maintain the index when doing inserts.
hope this is useful for your question.
======= 2005-06-27 19:24:06 you wrote：=======
>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 majordomo@postgresql.org
>
= = = = = = = = = = = = = = = = = = = =
Best regards!
李江华
Seamus Dean
Alibaba.com
TEL:0571-85022088-2287
ljh1469@alibaba-inc.com
2005-06-27
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ljh1469@alibaba-inc.com, praveen.raja@netlight.se
Subject: Re: Insert performance vs Table size
In-Reply-To: <20050627113053.6F2E466C097@smtp-hz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox