ERROR: could not load library "/opt/PostgreSQL/9.0/lib/postgresql/":
Published on Fri, Apr 29, 2011

Above error thrown, when I was trying to create language plperlu. It indicates that there is a missing library Check out the steps performed to overcome this issue and successfully creating the plperlu language in PostgreSQL. Method 1 (Finding the and making softlink to that location) postgres=# create LANGUAGE plperlu; ERROR: could not load library "/opt/PostgreSQL/9.0/lib/postgresql/": cannot open shared object file: No such file or directory postgres=# \q Now, search for the file libperl. Continue reading →

Size of Partition Table in PostgreSQL 9.0
Published on Wed, Apr 27, 2011

In PostgreSQL, every table is an object, using pg_relation_size(‘object_name’) will give the size of the object. If you send the partition table in the place of ‘object_name’, it gives only that object size but not the sizes of child tables. Check out the example given below. postgres=# \dt+ List of relations Schema | Name | Type | Owner | Size | Description --------+---------------+-------+----------+------------+------------- public | child1 | table | postgres | 8192 bytes | public | child2 | table | postgres | 8192 bytes | public | parent | table | postgres | 0 bytes | (3 rows) pg_relation_size() on parent table will not give the exact size. Continue reading →

PostgreSQL 9.0 Memory & Processes
Published on Mon, Apr 25, 2011

Going forward with PostgreSQL Architecture, here I would be discussing about the utility process and memory with informative links. Many of the commiters have already documented insightfully about the process and memory, links provided here for those. Modest presentation from my end about the PostgreSQL Utility Process. Every PostgreSQL Instance startup, there will be a set of utilty process(including mandatory and optional process) and memory. Two mandatory process (BGWRITER and WAL Writer) and four optional process (Autovacuum launcher,stats collector,syslogger, and Archiver). Continue reading →

PostgreSQL 9.0 Architecture
Published on Fri, Apr 22, 2011

Its my pleasure to be here, publishing my first blog on PostgreSQL Architecture. For a quite sometime, am working, learning the vast and most happening Database PostgreSQL. As a beginner,thought of giving a try to represent PostgreSQL Architecture in pictorial format. PostgreSQL Architecture includes sevaral things memory,process and storage file system, it is complex to show everything in one Picture. My efforts here to give an overview on PostgreSQL Architecture. Continue reading →