Hello All,
How Postgres Maintains data in Shared Buffer
Does It maintains queried data in memory or table data and Next time how
postgres fetch data from memory
rather than disk
Which algorithm is used for storing data how data is indexed in shared
buffers
Thanks
Siddharth
Albe Laurenz wrote:
Siddharth Shah wrote:
I am not using wall based replication ? I no not have frequent &
long transaction , need of checkpoints
Just want to get what data resides in pg_xlog that it takes 16MB without
any transactions.
It contains the transaction log files.
Richard Huxton wrote:
Siddharth Shah wrote:
Hi,
When I initialize database, pg_xlog direcory takes almost 17 MB size
Why pg_xlog/WAL takes 17 MB of size while there is no transaction
occurred ?
What is the content of pg_xlog , If it's only wal file it's must be
blan
Hi,
When I initialize database, pg_xlog direcory takes almost 17 MB size
Why pg_xlog/WAL takes 17 MB of size while there is no transaction
occurred ?
What is the content of pg_xlog , If it's only wal file it's must be
blank after on write of transaction on database.
regards,
Siddha
Tom Lane wrote:
Siddharth Shah <[EMAIL PROTECTED]> writes:
In My Application I have only 256MB storage device and I have to
manage many other application in same storage
Quite honestly, you're going to need some other database besides
Postgres if you need a disk footp
Albe Laurenz wrote:
Siddharth Shah wrote:
In My Application I have only 256MB storage device and I have to
manage many other application in same storage
So, have to remove use less files , From configuration disabling
unwanted options helps to reduce the size.
So, I need detail
Albe Laurenz wrote:
Siddharth Shah wrote:
I am compiling postgres, I have some doubts on ./configure options
--disable-largefile
Does it refers to for storing blob objects to store or
anything else ?
I couldn't find this configure switch in the documentation for
8
Albe Laurenz wrote:
Siddharth Shah wrote:
I am compiling postgres, I have some doubts on ./configure options
--enable-nls[=LANGUAGES] enable Native Language Support
Do I need to supply each language name which i am going to store
in my database or just have to take
Hi,
I am compiling postgres, I have some doubts on ./configure options
--enable-nls[=LANGUAGES] enable Native Language Support
Do I need to supply each language name which i am going to store
in my database or just have to take support UTF-8 ?
and
--disable-largefile
Does
Hello,
I have started to explore PG,
I have found pgstat.stat file taking too much write hits.
As my need to deploy on flash based storage. I don't want higher I/O's
To stop status collector process I have change postmaster.c by removing
calls of pgstat.c
Now every thing is working fine, Sta
10 matches
Mail list logo
