Hi all,
As I am inserting 100million rows daily into partitioned tables (daily wise),
it is getting slower. Even the retrivel of data, select statement on those
tables takes about 30 mintues. I have tried increasing the parameters in
postgres.conf but still that doesn't help me much as the
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of roopa perumalraja
Sent: Tuesday, February 06, 2007 12:33 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Storing database in cluster (Memory)
Hi all,
As I am inserting 100million rows daily into
roopa perumalraja wrote:
Hi all,
As I am inserting 100million rows daily into partitioned tables
(daily wise), it is getting slower.
What is - the inserts? By how much? What tables? What indexes? How are
you inserting these rows?
> Even the retrivel of data, select
statement on those table
] Storing database in cluster (Memory)
roopa perumalraja wrote:
> Hi all,
>
> As I am inserting 100million rows daily into partitioned tables
> (daily wise), it is getting slower.
What is - the inserts? By how much? What tables? What indexes? How are
you inserting these rows?
> Even
>>Hi all,
>>
>>As I am inserting 100million rows daily into partitioned tables (daily wise),
>>it is getting slower.
>What is - the inserts? By how much? What tables? What indexes? How are you
>inserting these rows?
I take my words back as 100million rows. The insert of 20million rows
every
roopa perumalraja wrote:
Hi all,
As I am inserting 100million rows daily into partitioned tables
(daily wise), it is getting slower.
What is - the inserts? By how much? What tables? What indexes? How
are you inserting these rows?
I take my words back as 100million rows. The insert of 20mill