PostgreSQL: Partitioned Table vs Non Partitioned Table (Part 3)

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...

PHP Script to Generate PostgreSQL Table Partitioning (Part 2)

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...

Create PostgreSQL Table Partitioning (Part 1)

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 -...

Partitioning PostgreSQL Tables – Handle Millions of Rows Efficiently

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 Goddard – What’s New, Overview, Features, Screenshots

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 Released – What’s new, Overview, Features, Screenshots

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...

PostgreSQL Sleep Function pg_sleep – Postgres Delay Execution

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...

PostgreSQL: Select a Random Number in a Range (Between Two Numbers)

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 12 Constantine is released

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...

if-not-true-then-false.com New Look

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:

Howto Install Gnome Shell with YUM on Fedora 12 Linux

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...

Delete files permanently with shred command in Linux – Remove absolutely

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 Hacked by Iranian Cyber Army

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:...
1 2 3 6 7 8 9
Close