This article compares the speed and performance of queries between partitioned and non partitioned PostgreSQL tables. However, it is important to remember that the PostgreSQL tables partitioning has also another benefits, than the better...
Currently Browsing Page 10
As Part 1 (Howto create PostgreSQL table partitioning) shows, making of PostgreSQL partitioning needs a lot of SQL commands. So this Part 2 explains how SQL commands for PostgreSQL partitioning can be made with a simple PHP script. This...
PostgreSQL supports partitioning via table inheritance. So the partitioning is made in such a way that every child table inherits single parent table. Parent table is empty and it exists just to describe the whole data set.
PostgreSQL...
PostgreSQL table partitioning means splitting one large database table into smaller logical pieces. PostgreSQL table partitioning will be worthwhile only when a table would be very large.
Here are a few benefits of what can be achieved...
Fedora 13 is released. This is overview, what’s new features found on new Fedora 13 release.
Main Software Updates, Changes and Features
New Software
Shotwell – Open source photo manager for GNOME
Deja-dup – Déjà Dup...
CentOS 5.5 is the fifth update to the CentOS 5 distribution series. It contains a lot of bugfixes, updates and new functionality.
New Packages on CentOS 5.5
freeradius2
gsl
postgresql84
python-dmidecode
samba3x
tunctl
xz
gpxe (x86_64...
One day, I was looking for PostgreSQL database function, which could delay the execution of queries. At first I thought that I will do one myself, because I do not remember ever seen this kind function. But then I found pg_sleep Postgres...
This is quick tip howto select a random number in a range. Example random number between 1-100 (>= 1 and < 100). This is actually very easy job with PostgreSQL own random() function, which returns random value between 0-1. Following...
Fedora team promises to bring to you the latest and greatest release of Fedora ever, Fedora 12! Many things are really changed and improved. Fedora 12 also brings lots of new packages.
Here is some highlights from Fedora 12 new...
This new design (using Arras Theme) has just been published and will still develop, so any comments and opinions are very welcome.
In my opinion, the new layout is much lighter and clearer. Also blog’s content is intended to bring...
Here is a list of the best Google Chrome Search Engine Optimization (SEO) extensions (plugins).
Search Engine Optimization (SEO) Extensions
Chrome SEO
The Google Chrome SEO Extension. Make your SEO tasks easier with Chrome SEO Tools,...
What is Gnome Shell?
GNOME Shell is the defining technology of the GNOME 3 desktop user experience.
It provides following core interface functions:
Launching applications
Opening files
Switching between open windows
Adding and deleting...
I before post ‘Twitter Hacked by Iranian Cyber Army’, but actually just Twitter DNS records was hacked. I think even twitter.com server headers and tracepath to servers simply prove this, because they are completely different...
Sometimes need to delete files whose contents should disappear absolutely, completely and safely. Linux command rm just remove file and it is still possible to dig out from the disk. Fortunately for Linux can be found in shred program...
Twitter site is hacked by Iranian Cyber Army. Here is some screenshots and full info about page.
Screenshots
Server info and full html content
lynx -mime_header http://twitter.com
HTTP/1.1 200 OK
Date: Fri, 18 Dec 2009 06:42:08...