|
Hi Scott, Thanks for your reply and pls see my inline comments in red color. Regards, G. V. Suresh Gupta --------------------------------------------------------------------------------------------------------------------------------- Innovative Technology Solutions(ITS), Zensar Technologies Kharadi, Off Landline :
+91-20-66453471 |
+91-9890898688
Email :
suresh.g@xxxxxxxxxx | website: www.zensar.com -----Original Message----- On Jan 3, 2008 5:33 AM, > > Hi Team, > > I am using Postgresql 7.4.2 version on Solaris. You need to update to 7.4.18 or whatever the last version was.
7.4.2 has known data eating bugs, and if you value your data even a little, you should update. this is a relatively painless update not
requiring a dump / restore. Suresh : Can you pls tell
is 7.4.2 is latest or 7.4.18 is latest? We will plan to upgrade to 8.2.5. > There are number of tables > say about 30+ tables in our database. I started to
"reindex" the tables > individually. "reindex table <<table
name>>". All the queries executed > normally with less than 1 minute of duration. But one table is not > responding any thing even after 10 minutes. The details of the
table are … I've had large tables take well over 10 minutes on 7.4 to reindex. That's not necessarily a sign of a problem. How many rows does
this table have? Do you get any kind of error message or the database just never returns. Have you tried vacuum full on this table
instead? Do the logs say anything about the reindex operation getting an error etc??? Suresh : This table contains only 5 columns and 5 rows of data.
I don’t get any error message instead it remains un answered, I am using “ctrl
C” to cancel the command. I also had done the vacuum on this table, pls
see the result below. Pls give the general path of log files available in the
database. I don’t have idea of this logs files of PGSQL. commercelink=# vacuum
verbose analyze currency; INFO: vacuuming
"public.currency" INFO: index
"currency_pkey" now contains 5 row versions in 2 pages DETAIL: 0 index pages
have been deleted, 0 are currently reusable. CPU 0.00s/0.00u sec elapsed
0.00 sec. INFO:
"currency": found 0 removable, 5 nonremovable row versions in 1 pages DETAIL: 0 dead row
versions cannot be removed yet. There were 3 unused item
pointers. 0 pages are entirely empty. CPU 0.00s/0.00u sec elapsed
0.00 sec. INFO: analyzing
"public.currency" INFO:
"currency": 1 pages, 5 rows sampled, 5 estimated total rows VACUUM commercelink=# reindex
table currency; ^CCancel request sent ERROR: canceling
query due to user request commercelink=# > Can you please tell me why it not executing this command on the
particular > table and I am the owner of the DB? Can you please suggest some
thing. Is it really not executing? Is it simply returning without a
notice, or hanging? Suresh : It is not
executing at all. It is not hanging, I am canceling the query by giving “ctrl
c”. Then it is giving me the database prompt as usual. > We > found these days, the database is taking more time to execute any
query. We > are doing "vacuum Verbose analyze" regularly at low
traffic time. You would do well to consider a migration to 8.2.5 or 8.3 when it comes out of beta / RC status. 7.4.x is getting rather old, and
the 8.x series (8.0, 8.1, 8.2, and now 8.3) have each had major improvements in speed. Suresh : We will plan to upgrade to 8.X.
What is this beta / RC status, can you brief me pls? DISCLAIMER: |
