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
everyday takes
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
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
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 dev@archonet.com wrote:
roopa perumalraja wrote:
Hi all,
While
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
. 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
Sent: Sunday, January
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
) No concurrent activities, means I run one command at a time.6) Nothing else running on the box other than Postgres.I hope these answers will try to solve my problem. Thanks again.Roopa Michael Fuhr [EMAIL PROTECTED] wrote: On Tue, Oct 17, 2006 at 07:26:25PM -0700, roopa perumalraja
, 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 questions below. 1 2) System: Microsoft Windows XP Professional Version 2002 Computer: Intel Pentium CPU
HiI 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 prettyslow. 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 call
HiCurrently 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
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