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 tables takes about 30 mintues.
All selects take 30 minutes, regardless what work they do? Or do you
have specific selects that are causing problems?
> I have tried
increasing the parameters in postgres.conf but still that doesn't
help me much as the no of rows are huge.
What parameters, to what values? What hardware are you running on? What
load do you place on it?
> Will the idea of storing the
database in cluster (memory) increase the performance of
insert/update/select in the table in a suitation like this? Thanks a
lot in advance.
A better question would be "Why isn't my data being cached?". The
operating-system should cache regularly used files.
Still - more details please roopa and we'll see if anyone can help you.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend