Postgres Pro
Downloads
Home   >   mailing lists

Re: Does pgsql database (file) size increases automatically as we put data? - Mailing list pgsql-novice

From Michael Swierczek
Subject Re: Does pgsql database (file) size increases automatically as we put data?
Date
Msg-id 68b5b5880910190604k3d34f18ey11b9cacf978f3194@mail.gmail.com
Whole thread Raw
In response to Does pgsql database (file) size increases automatically as we put data?  (leela <its_leela@yahoo.com>)
List pgsql-novice
Tree view
On Mon, Oct 19, 2009 at 6:33 AM, leela <its_leela@yahoo.com> wrote:
Hi All,
 Iam Leela from India.

I am new to using PGSQL..

I have a basic query about the FILE SIZE of database file..

Does pgsql database (file) size increases automatically as we put data or are there any things specific which we do during installation that restricts file size, etc?

Thanks & Regards,
Leela

From cricket scores to your friends. Try the Yahoo! India Homepage!

Leela,
File size increases automatically.  

However, not every SQL insert or SQL update will make a file larger, and not every SQL delete will make it smaller.  As data in the file becomes obsolete because of a delete or update, that section of the file is marked unused.  Later, when new data is inserted into the file, the new data can be appended to the end of the file or inserted into one of the places that contained obsolete data. 

-Mike

pgsql-novice by date:

Previous
From: leela
Date:
Subject: Does pgsql database (file) size increases automatically as we put data?
Next
From: Josh Kupershmidt
Date:
Subject: Re: Does pgsql database (file) size increases automatically as we put data?