It seems that postgresql has not been startup yet at the moment, because other SQL commands can be executed even after the error. This phenomenon happened at one of our customer and I suggested to execute pg_dump after some minutes, and not soon after postgresql being started.
Thank you very much, rski and hikmat.
melaniejp
Last Activity: Oct 27 '11, 06:34 AM
Joined: Sep 1 '11
Location:
-
Thank you rski and Rabbit.
The data in table1 are created for test.
Col0 and col4 are all the same, only col2 is different.
In this case, col0=140 matches all records in the table and it the same as full scan,right?
I tested some patterns and elapsed time were almost the same.
(1)create index table1_idx on table1(col0,col 2,upper(col4));
(2)create index table1_idx on table1(col0,col 2,col4,upper(co l4));...Leave a comment:
-
Please advise a better index
I created an index for a table but the performance increased just a little.
What the problem is and how should I create the index?
The SQL cannot be changed and only an index is required to increase the performance.
The following is detailed enviorenment.
(1)DB: Oracle10.2.0.3
(2)SQL:
select * from
(SELECT col1,col2, col3, col4 FROM table1
where col0 = 140 AND
col2>=to_date(' 2011-08-30','YYYY-MM-DD')... -
re: pg_dump fails with error "The database system is starting up"
>What do you mean "even after the error".
>Is the database working correctly?
Yes. Only pg_dump fails.Leave a comment:
-
pg_dump fails with error "The database system is starting up"
One of our customers who using PostgreSQL7.2.1 encountered the following error when they back up the database using pg_dump.exe.
[command]:
pg_dump.exe -f <filename> <dbname>
[error message]:
pg_dump.exe: [archiver (db)] connection to database "<dbname>" failed: FATAL 1: The database system is starting up
When "The database system is starting up" error...
No activity results to display
Leave a comment: