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