[ADMIN] Space occupied by Postgres index.

Hi, I am facing a problem where indexes creates on some tables are occupying huge space on disk and it seems to me that this space is not getting reclaimed even when there are very few record in an associated table. When I ran full vacuum the disk space was reclaimed occupied by tables but

Re: [ADMIN] Space occupied by Postgres index.

[mailto:k...@rice.edu] Sent: Tuesday, November 30, 2010 10:59 PM To: Shridhar Polas Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Space occupied by Postgres index. On Tue, Nov 30, 2010 at 10:56:53PM +0530, Shridhar Polas wrote: > Hi, > > > > I am facing a problem where indexes

[ADMIN] Triggers on system catalog

Hi, Is there a way to create triggers on system catalog tables like pg_class, pg_attribute etc...? Thanks, Shridhar

[ADMIN] Deadlock like scenario

Hi, I am experience the problem where locks acquired by postgres are NOT getting released. The use case is something like:- . There is a table let's say "A" and the trigger is created on this table let say "A_TRIGGER". . The trigger captures the data change happens in