Re: [GENERAL] postgres table have a large number of relpages and occupied a big memory size

2011-08-09 Thread Vivekkumar Pandey
On Tue, Aug 9, 2011 at 2:59 PM, Tomas Vondra wrote: > On 9 Srpen 2011, 9:18, Vivekkumar Pandey wrote: >> I have seen that autovacuum takes long time to process . >> please give me the reason .. > > What do you mean by "takes long time to process"? How do yo

Re: [GENERAL] postgres table have a large number of relpages and occupied a big memory size

2011-08-09 Thread Vivekkumar Pandey
I have seen that autovacuum takes long time to process . please give me the reason .. On Mon, Aug 8, 2011 at 2:10 PM, Tomas Vondra wrote: > On 8 Srpen 2011, 8:02, Vivekkumar Pandey wrote: >> Hi , >> >>       I have version of Post

Re: [GENERAL] postgres table have a large number of relpages and occupied a big memory size

2011-08-07 Thread Vivekkumar Pandey
bnormally. On Sat, Aug 6, 2011 at 12:12 AM, Jaime Casanova wrote: > On Fri, Aug 5, 2011 at 5:26 AM, Tomas Vondra wrote: >> On 5 Srpen 2011, 10:52, Vivekkumar Pandey wrote: >> >>> Also suggest the Query that can view the dead tuples in the table. >> >> You can

Re: [GENERAL] postgres table have a large number of relpages and occupied a big memory size

2011-08-05 Thread Vivekkumar Pandey
... On Fri, Aug 5, 2011 at 1:22 PM, Jaime Casanova wrote: > On Fri, Aug 5, 2011 at 2:37 AM, Vivekkumar Pandey > wrote: >> >> Hi Tomas, >> >>    I am using the slony cluster and both the database have the same Data. >> >> So Please provide the appropriate solut

Re: [GENERAL] postgres table have a large number of relpages and occupied a big memory size

2011-08-05 Thread Vivekkumar Pandey
Hi Tomas, I am using the slony cluster and both the database have the same Data. So Please provide the appropriate solution On Fri, Aug 5, 2011 at 12:47 PM, Tomas Vondra wrote: > On 5 Srpen 2011, 9:00, Vivekkumar Pandey wrote: >> Hi all, >> >>        I have a cl

[GENERAL] postgres table have a large number of relpages and occupied a big memory size

2011-08-05 Thread Vivekkumar Pandey
Hi all, I have a cluster database with a master and slave , the size of master database is very high reltive to slave while both have approximatly same data. On master # select pg_size_pretty(pg_database_size('table_name')); pg_size_pretty 15 GB (1 ro