-admin@postgresql.org
Subject: Re: [ADMIN] Need some info on Postgresql
On Jan 7, 2008 3:41 AM, Suresh Gupta VG [EMAIL PROTECTED] wrote:
Hi Scott,
Thanks for your reply. Pls find the attached file for the output of
the
command given by you. The reindex problem is coming for the table
On Jan 8, 2008 1:39 AM, Suresh Gupta VG [EMAIL PROTECTED] wrote:
Thanks Scott for your reply.
Actually, our application will extract all the data from currency table and
never uses that table later at all. I don't know which process is locking
that table. Pls find the attached file for the
On Jan 4, 2008 12:41 AM, Suresh Gupta VG [EMAIL PROTECTED] wrote:
Hi Scott,
Thanks for your reply and pls see my inline comments in red color.
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
On Jan 4, 2008 4:40 AM, Scott Marlowe [EMAIL PROTECTED] wrote:
http://www.postgresql.org/ says the latest minor update to the 7.4
branch is 7.4.18. You are missing over two years of bug fixes by
running 7.4.2. updating to 7.4.2 will take minutes.
Correction, should be updating to 7.4.18 will
On Jan 4, 2008 5:14 AM, Suresh Gupta VG [EMAIL PROTECTED] wrote:
Hi Scott,
Thanks for your reply.
I got the result for the query select * from pg_locks; as below. Can you
explain me the output please.
relation | database | transaction | pid | mode | granted
[mailto:[EMAIL PROTECTED]
Sent: Friday, January 04, 2008 7:53 AM
To: Suresh Gupta VG
Cc: Peter Koczan; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Need some info on Postgresql
On Jan 3, 2008 5:33 AM, Suresh Gupta VG [EMAIL PROTECTED] wrote:
Hi Team,
I am using Postgresql 7.4.2 version
Hi Team,
I am using Postgresql 7.4.2 version on Solaris. 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
On Jan 3, 2008 5:33 AM, Suresh Gupta VG [EMAIL PROTECTED] wrote:
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