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 you measure it?
>
> Autovacuum is meant
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 you measure it?
Autovacuum is meant as a background process, and it should run on
background and n
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 PostgreSQL as given below:---
>>
>>
On 8 Srpen 2011, 8:02, Vivekkumar Pandey wrote:
> Hi ,
>
> I have version of PostgreSQL as given below:---
>
>version
> -
> PostgreSQL 8.1.2 on i686-pc-linux-gnu, compi
Hi ,
I have version of PostgreSQL as given below:---
version
-
PostgreSQL 8.1.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
3.3.3 (SuSE Linux)
And it does't have
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't see the dead tuples with a query - that's why they're called
> dead.
you can see an estimate of how many dea
On 5 Srpen 2011, 10:52, Vivekkumar Pandey wrote:
> Hi,
> slon process is running on the system .
>
> Now , I have a question that Why dead tupples are remains in the table
> while AUTOVACUUM process running at the fixed interval of time without
> any error.
Well, because that's how vacuum works. V
Hi,
slon process is running on the system .
Now , I have a question that Why dead tupples are remains in the table
while AUTOVACUUM process running at the fixed interval of time without
any error.
Also suggest the Query that can view the dead tuples in the table.
Thanks for instant reply...
O
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 solution
>
> On Fri, Aug 5, 2011 at 12:47 PM, Tomas Vondra wrote:
> >
> > That suggests you're using somet
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 cluster database with a mas
On 5 Srpen 2011, 9:00, Vivekkumar Pandey wrote:
> 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.
What version of PostgreSQL is this, what kind of cluster, and what
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
12 matches
Mail list logo
