Re: [GENERAL] Why index occupy less amount of space than the table with same structure.

ot and the space occupied is exactly half of the table in indexes. Can you explain a bit on this. Thanks in Advance Regards Raghavendra On Sun, Mar 28, 2010 at 4:52 PM, Alban Hertroys < dal...@solfertje.student.utwente.nl> wrote: > On 28 Mar 2010, at 10:05, Tadipathri Raghu wrot

[GENERAL] Why index occupy less amount of space than the table with same structure.

Hi All, Here is small testing done by my end and am curious to know the reason. Please find the example given below:- postgres=# create table size_test(id int); CREATE TABLE postgres=# insert into size_test VALUES (generate_series(1,100)); INSERT 0 100 postgres=# select pg_size_pretty(pg_

Re: [GENERAL] How many Mandatory Process are there in Postgres

26, 2010 at 9:22 AM, Scott Marlowe wrote: > On Thu, Mar 25, 2010 at 9:03 PM, Tadipathri Raghu > wrote: > > Hi Scott, Thomas, > > > > Thank you for the update. > > > >> > >> >> Oracle uses a completely different implementation of MVCC > arch

Re: [GENERAL] How many Mandatory Process are there in Postgres

> > Hi Scott, Thomas, Thank you for the update. > >> Oracle uses a completely different implementation of MVCC > architecture. > >> It > >> overwrites the data and then uses rollback segments to provide 'previous > >> versions' to running transactions etc. > >> > >> PostgreSQL does not overwrit

Re: [GENERAL] How many Mandatory Process are there in Postgres

Hi Tomas, Thank you for the reply. > Well, there is a bunch of processes started at the beginning, and then > there is one backend process for each connection (see the postgresql.conf > how many connections are allowed in your case). > I do agree with you, that there would be bunch of process.

[GENERAL] How many Mandatory Process are there in Postgres

Hi All, When we start the postgres server, the writer process, wal process, postmaster, autovacuum ( if autovacuum is on), stats collector will come into picture as mandotory process. My question is, is there any processes apart from these process, what are the mandotory process come along with th

Re: [GENERAL] "\d pg_class" fails in PG 8.4

Hi Tom, As you are best always on this Community Fourm. Thanks for your help. It got resolved. Regards Raghavendra On Thu, Mar 25, 2010 at 10:03 AM, Tom Lane wrote: > Tadipathri Raghu writes: > > Following is the error when i try to describe the catalog table. > > > post

Re: [GENERAL] How to retrive List of Tables in a Database using...

Hi Yogi Yang, Psql is a very strong tool, and easy to use. Please find the answers for your queries >>1. Retrieve list of all Tables in a database >>2. Retrieve list of all Functions, Triggers, Sequences, Views, etc. >>3. Retrieve list of all Group Roles postgres=#\d{t|i|s|v|S|g|n} you can use a

[GENERAL] "\d pg_class" fails in PG 8.4

Hi All, Following is the error when i try to describe the catalog table. Version Info postgres=# select version(); version ---