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 performance on queries. More information about other benefits from the first part 'Howto create PostgreSQL table partitioning (Part 1)'.
This is comparision between partitioned and non partitioned PostgreSQL tables. The same tests were carried out with and...
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 example script make SQL for child tables, indexes, trigger function and parent table trigger. This example script can make PostgreSQL table partitioning with using Date ranges. Script can be configured with following configuration section:
Initial...
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 partitioning can be implemented in range partitioning or list partitioning.
Range partitioning can be done for example by ID ranges (like 0-100 000, 100 001-200 000, 200 001-300 000...) or Date ranges (like 2009-11-01 - 2009-11-30, 2009-12-01 -...
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 with partitioning:
Large tables query performance can be improved dramatically
Reducing index size and making it more likely that the heavily-used parts of the indexes fit in memory
Rarely used data can be moved to slower and cheaper storage...
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 (day-ja-doop) is a simple backup tool. It hides the complexity of doing backups the Right Way (encrypted, off-site, and regular) and uses duplicity as the backend.
Pino - Twitter and Identi.ca client for Linux desktop
Simple Scan - Simple Scanning Utility
New...
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 only)
Some package updates
exim 4.63
gcc 4.1.2
kernel 2.6.18
OpenOffice.org 3.1.1
php 5.1.6
xen 3.0.3
yum 3.2.22
httpd 2.2.3
Most interesting update is PostgreSQL 8.4. Of course, many have used the 8.4 version of PostgreSQL on...
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 function which directly delay execution of the server process.
pg_sleep makes the current session's process sleep until seconds seconds have elapsed. Seconds is a value of type double precision, so fractional-second delays can be specified.
pg_sleep...
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 example selects 5 random values using generate_series() function:
SELECT random() FROM generate_series(1,5);
random
-------------------
0.595817462075502
0.350072300527245
0.989073566626757
0.700899163261056
0.940509075298905
(5...
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 stuff
Optimized performance - 32-bit architecture software packages have been compiled with special optimization for the Intel Atom processors without losing compatibility with the overwhelming majority of CPUs.
Smaller and faster updates - Fedora 12 uses...
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 out clearer for blog readers and users.
Please leave comment and tell your opinion!
Old layout screenshot:
New layout screenshot:
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, includes 'all' the stats and data you need.
Install Extension
(more…)
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 workspaces
Moving windows between workspaces
Dynamic system-related information display (including transient notifications)
Providing a flat list of user-account related actions
Logging out or switching the session, and stopping or...
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 normally when hacked.
Hacked twitter.com headers:
(more…)
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 that removes the files permanently. Shred command is easy and quickly to use cases when files need to deleted forever.
Shred command usage
Create test file:
echo "testing testing" > /tmp/test.txt
Delete file with shred command:
shred -v -n 25 -u...
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 GMT
Server: Apache/2.2.14 (Unix) mod_ssl/2.2.14 OpenSSL/0.9.8l DAV/2 mod_auth_passthrough/2.1 FrontPage/5.0.2.2635
Last-Modified: Fri, 18 Dec 2009 06:21:13 GMT
ETag: "90c06a-717-47afabf13c840"
Accept-Ranges: bytes
Content-Length:...
« Previous
1
2
3
…
6
7
8
9