On 05/03/10 15:14, akp geek wrote:
Hi All -
I have turned on the auto vacuum on the slave and for some
reason the db is getting bloated up. The master size is only 1G and the
slave is at 9.2GB now. I did cluster on couple of tables also. did any one
run into this situation? Can
Hi All -
I have turned on the auto vacuum on the slave and for some
reason the db is getting bloated up. The master size is only 1G and the
slave is at 9.2GB now. I did cluster on couple of tables also. did any one
run into this situation? Can you please help?
Regards
2010/3/3 ak
I just made changes to postgresql.conf to make sure the autovacuum is turned
on and I will update you.. Again thanks for your time
Regards
2010/3/3 Devrim GÜNDÜZ
> On Wed, 2010-03-03 at 08:32 -0500, akp geek wrote:
> > Thank you all for the suggestions. I did a vacuum and the size has
> > gone
On Wed, 2010-03-03 at 08:32 -0500, akp geek wrote:
> Thank you all for the suggestions. I did a vacuum and the size has
> gone down drastically. But still it is not the same size as my master.
> I am looking into it
Plain vacuum does not file system size of relations. It just marks dead
spaces ar
On 03/03/10 13:32, akp geek wrote:
Thank you all for the suggestions. I did a vacuum and the size has gone down
drastically. But still it is not the same size as my master. I am looking
into it
Check your autovacuum settings and you should be able to keep things
stable at least.
You might ne
Thank you all for the suggestions. I did a vacuum and the size has gone down
drastically. But still it is not the same size as my master. I am looking
into it
Appreicate your help
On Wed, Mar 3, 2010 at 4:41 AM, Richard Huxton wrote:
> On 02/03/10 21:47, akp geek wrote:
>
>> I am doing a replic
On 02/03/10 21:47, akp geek wrote:
I am doing a replication of one of the database and the size of the slave
database is growing exponentially . Right now the size of master db is 849M
and the slave is 7GB.
my master is 8.3 and slave is 8.4
I'm guessing your slave isn't being vacuumed. Or, p
I am doing a replication of one of the database and the size of the slave
database is growing exponentially . Right now the size of master db is 849M
and the slave is 7GB.
When I noticed the base directory on the slave , that's when I noticed the
fsm and vm files and raised the question.
is there
Those are the free space map / visibility map files. There is going to be
one of each for every relation.
No worries :-) They are supposed to be there:
http://wiki.postgresql.org/wiki/Segment_Visibility_Map
Don't clean them up, doing so could be disastrous. Actually, if I were
you, I wo
akp geek wrote on 02.03.2010 22:11:
Hi all -
There are lot of FSM and VM files getting generated in
the base directory. Do we need these files and I don't know the reason
why these files are getting generated. I read the documentation, but not
able to follow well. I will read it ag
Hi all -
There are lot of FSM and VM files getting generated in the
base directory. Do we need these files and I don't know the reason why these
files are getting generated. I read the documentation, but not able to
follow well. I will read it again. But do we need to keep these file
11 matches
Mail list logo
