Tags » Postgresql

How cursors degrade the performance of an SQL?

I would like to share with you all some points relating to the usage of cursors in an SQL programming code. Be it either T-SQL, PL/SQL, PL/pgSQL or any Programming Language of any RDBMS. 959 more words

Postgresql

DELETE all same link but skip max(id) link

DELETE from HISQC where id in (select b.id from (select link from HISQC group by link having count(*)>1 ) as a left join (select id,link from HISQC where id not in (select max(id) from HISQC group by link having count(*)>1)) as b on a.link=b.link)

Postgresql

Advantages of PostgreSQL over MS SQL Server

MS SQL Server is proprietary database from Microsoft, while on the other side, PostgreSQL is developed and maintained by a global community of open source developers and companies. 215 more words

SQL Server

Apa yang membuat PostgreSQl berbeda?

apa yang membuat PostgreSQl berbeda adalah PostgreSQl adalah database pertama yang mengimplementasikan multi-version concurency control (MVCC) bahkan sebelum Oracle. fitur ini dikenal sebagai snapshot isolation di Oracle. 71 more words

PostgreSQl

Apakah postgresql itu?

apakah postgresql itu?

rangkuman : dalam tutorial ini anda akan belajar tentang PostgreSQL dan fitur yang membuat PostgreSQl menonjol dibanding database manajemen lainnya.

apakah PostgreSQl itu? 130 more words

PostgreSQl

RDBMS Data Limit

== Microsoft SQL Server ==
Max DB Size: 524,272 TB (32 767 files * 16 TB max file size)
Max Table Size: 524,272 TB
Max Row Size: 8,060 bytes (Unlimited) 269 more words

Development

PostgreSQL WITH RECURSIVE

create table empl (
    name text primary key,
    boss text null
        references name 
            on update cascade 
            on delete cascade 
        default null
);

insert into empl values ('Paul',null);
insert into empl values ('Luke','Paul');
insert into empl values ('Kate','Paul');
insert into empl values ('Marge','Kate');
insert into empl values ('Edith','Kate');
insert into empl values ('Pam','Kate');
insert into empl values ('Carol','Luke');
insert into empl values ('John','Luke');
insert into empl values ('Jack','Carol');
insert into empl values ('Alex','Carol');

… 52 more words
POSTGRESQL