We have a view in our database.
CREATE view public.hogs AS
SELECT pg_stat_activity.procpid, pg_stat_activity.usename,
pg_stat_activity.current_query
FROM ONLY pg_stat_activity;
Select current_query from public.hogs helps us to spot errant queries
at times.
regds
mallah.
On 12/7/06, asif
Thanks Scott,
It worked!!!
We killed an old idle running transaction, now everything is fine..
Thanks Again
asif ali
icrossing inc
Scott Marlowe <[EMAIL PROTECTED]> wrote: On Wed, 2006-12-06 at 15:53, asif ali
wrote:
> Thanks Everybody for helping me out.
> I checked "pg_stat_activity"/pg_
On Wed, 2006-12-06 at 15:53, asif ali wrote:
> Thanks Everybody for helping me out.
> I checked "pg_stat_activity"/pg_locks, but do not see any activity on
> the table.
> How to find a old running transaction...
> I saw this link, but it did not help..
> http://archives.postgresql.org/pgsql-hacker
Thanks Everybody for helping me out.
I checked "pg_stat_activity"/pg_locks, but do not see any activity on the
table.
How to find a old running transaction...
I saw this link, but it did not help..
http://archives.postgresql.org/pgsql-hackers/2005-02/msg00760.php
Thanks
asif ali
icross
asif ali <[EMAIL PROTECTED]> writes:
> INFO: vacuuming "public.product_table"
> INFO: "product_table": found 0 removable, 139178 nonremovable row versions
> in 4305 pages
> DETAIL: 138859 dead row versions cannot be removed yet.
So Scott's guess was correct: you've got a whole lot of dead r
Thanks for the prompt reply...
Here is the output of "VACUUM FULL VERBOSE"
The postgres version is "8.0.3".
Thanks
asif ali
icrossing inc
INFO: vacuuming "public.product_table"
INFO: "product_table": found 0 removable, 139178 nonremovable row versions in
4305 pages
DETAIL: 138859 de
On 12/6/06, asif ali <[EMAIL PROTECTED]> wrote:
Hi,
I have a "product" table having 350 records. It takes approx 1.8 seconds to
get all records from this table. I copies this table to a "product_temp"
table and run the same query to select all records; and it took 10ms(much
faster).
I did "VACU
On Wed, 2006-12-06 at 11:07, asif ali wrote:
> Hi,
> I have a "product" table having 350 records. It takes approx 1.8
> seconds to get all records from this table. I copies this table to a
> "product_temp" table and run the same query to select all records; and
> it took 10ms(much faster).
> I did
2006/12/6, asif ali <[EMAIL PROTECTED]>:
Hi,
I have a "product" table having 350 records. It takes approx 1.8 seconds to
get all records from this table. I copies this table to a "product_temp"
table and run the same query to select all records; and it took 10ms(much
faster).
I did "VACUUM FULL
