>>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
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
Thanks a lot for your reply. To make it more clear will the be no loss of data
or data corruption when taking a base backup while there is inserts & updates
happening in the database?
--
Roopa
Richard Huxton wrote:
roopa perumalraja wrote:
> Hi all,
>
> While ther
Hi all,
While there are inserts & updates happening into the database, is it possible
to make the base backup without losing any of the updates in the database?
What does select pg_start_backup('label'); & pg_stop_backup(); do actually?
I am worried if the file system backup tool
tables. But you won't be
able to
restrict the backup to specific rows. (You can always create a separate
table just for backups,
and dump just that table).
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of roopa perumalraja
S
Hi all,
Is it possible to back up only part of my database for example from tables
which have data from April to July 2006, if so what will be the command for
that.
Thanks a lot in advance
Roopa
-
It's here! Your new message!
Get new email alerts w
Hi all, I am drawing the schema diagram for my postgres database. I wanted to add child tables to the master table in my diagram but I am not sure how to do it. I couldnt find any sample diagram for this in the web. If somebody can help me out with this that will be great. Thanks a lot for
) will this help? louis gonzales <[EMAIL PROTECTED]> wrote: also, runEXPLAINon any command, show the results of
this. In particular, if you have some commands that are taking 'even longer?'roopa perumalraja wrote:> Thanks for your reply.> > I have answered your question
2006 at 07:26:25PM -0700, roopa perumalraja wrote:> I would like to know that what can be the maximum size of database in> postgres 8.1.4.http://www.postgresql.org/docs/faqs.FAQ.html#item4.4> Currently my database size is 37GB & its pretty slow. I wonder if> its b'cos of huge
Hi Currently my database size is 38GB and it is pretty slow in whatever I do with it like take a backing up, vaccuming, reindexing, running all queries. Why is that? Is it possible to improve the performance. Thanks in advance Roopa
Yahoo! Messenger with Voice. Make PC-to-Phone Calls
Hi I would like to know that what can be the maximum size of database in postgres 8.1.4. Currently my database size is 37GB & its pretty slow. I wonder if its b'cos of huge amount of data in it. Thanks in advance. Roopa
How low will we go? Check out Yahoo! Messengers low PC-to-Phone c
I am new to postgres and I have 4 doubts. 1) I have a performance problem as I am trying to insert around 60 million rows to a table which is partitioned. So first I copied the .csv file which contains data, with COPY command to a temp table which was quick. It took only 15 to 20 minutes. Now I
I am new to postgres and I have 4 doubts. 1) I have a performance problem as I am trying to insert around 60 million rows to a table which is partitioned. So first I copied the .csv file which contains data, with COPY command to a temp table which was quick. It took only 15 to 20 minutes. Now I
13 matches
Mail list logo
