Skip to main content

Posts

Showing posts from September, 2011

PostgreSQL Database Growth

Hi ,

Here you can find the code for finding the DB Growth Percentage in PostgreSQL.

Required TABLE:-
-------------------
CREATE TABLE PGBAR_PGG.DBSIZES(TIME_STMP TIMESTAMP DEFAULT NOW(),DATNAME VARCHAR(100) NOT NULL,DATSIZE BIGINT NOT NULL,DBGROWTH VARCHAR(100),DBGROWTHPERCENT REAL);

Required Function For Trigger:-
---------------------------------
CREATE OR REPLACE FUNCTION PGBAR_PGG.FEED_DB_GROWTH()
RETURNS TRIGGER
LANGUAGE PLPGSQL
AS $FUNCTION$
DECLARE
CHECK_DB_PRESENCE INT;
PREV_DB_SIZE BIGINT;
BEGIN
SELECT COUNT(*) INTO CHECK_DB_PRESENCE FROM PGBAR_PGG.DBSIZES WHERE LOWER(DATNAME)=NEW.DATNAME;
IF(CHECK_DB_PRESENCE=0) THEN
RETURN NEW;
ELSE
SELECT DATSIZE INTO PREV_DB_SIZE FROM PGBAR_PGG.DBSIZES WHERE (CTID,DATNAME) IN (SELECT MAX(CTID),DATNAME FROM PGBAR_PGG.DBSIZES GROUP BY DATNAME HAVING DATNAME=NEW.DATNAME);
IF(PREV_DB_SIZE!=NEW.DATSIZE) THEN
SELECT PG_SIZE_PRETTY(NEW.DATSIZE::BIGINT-PREV_DB_SIZE) INTO NEW.DBGROWTH;
SELECT ((NEW.DATSIZE::REAL-PREV_DB_SIZE::REAL)/PREV_DB_SIZ…

Circle in C with ASCII

Hi ,

Here is the small program,generating a circle in c with ASCII in linux environment.

Surface:50X50
Radius:15
Formula: (x-CC)2+(y-CC)2=radius2

Here CC=Circle Center
x,y are the surface pointers.

#include "stdio.h"
#include "math.h"
int main()
{
int i,j,rad;
rad=15;
for (i=0; i<50; i++)
{
for (j=0; j<50; j++)
{
if(sqrt((j-(50)/2)*(j-(50)/2) + (i-(50)/2)*(i-(50)/2))<=rad)
printf(".");
else
printf(" ");
}
printf("\n");
}
return 0;
}

Complile:-
--------------
gcc -o circ circ.c -lm

Table related sequences

Hi,

Here is the query in PostgreSQL finds the list of tables and it's related sequences.


postgres=# SELECT TAB_SEQ_LIST.TABLE,TAB_SEQ_LIST.attname AS Columnname,TAB_SEQ_LIST.nspname AS Schemaname,case when position((nspname||'.')::varchar in TAB_SEQ_LIST.sequence_def)>0 then TAB_SEQ_LIST.sequence_def when position('.'::varchar in TAB_SEQ_LIST.sequence_def)>0 then TAB_SEQ_LIST.sequence_def when position('.'::varchar in TAB_SEQ_LIST.sequence_def)=0 and length(TAB_SEQ_LIST.sequence_def)>=1 then 'public.'||sequence_def else (select nspname from pg_class,pg_namespace where relkind='S' and relnamespace=pg_namespace.oid and relname=TAB_SEQ_LIST.sequence_def and pg_namespace.nspname=TAB_SEQ_LIST.nspname)::text||'.'||TAB_SEQ_LIST.sequence_def end as sequence_name FROM ( SELECT a.attrelid::regclass as table,attrelid ,attname,nspname,(select trim(both '''' from rtrim(ltrim(regexp_replace(regexp_replace(regexp_replace(ca…