05-12-2012
Index server
Hi guys,
I have postgresql server with huge amount of data, nearly 2 billion records. each record is at most 50 bytes(4 integer fields). I need to build index on all column to do fast reporting. but indexes becomes bloat after some time. almost 80% of database size is because of its huge indexes. I need some comprehensive external indexing solution so I remove indexes on DB. I found Lucene but it is for full text searching. my fields are all integer. Is there any good solution?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi, can anyone explain me how this works (how the flow goes)?
Example:
CLIENT="UNIXHELP"
The second argument passed $2="UNIX"
RESULT=`awk -F"=" '/CLIENTS=/ {len = index($2,"'${CLIENT}'");print len }' $2`
Thanks in advance. (1 Reply)
Discussion started by: abrd600
1 Replies
2. Shell Programming and Scripting
hi, :)
In a shell script i came accross the following lines
1.for i in ` find /home/oracle -name ch'
2.do
3.echo $i
4.idx=`expr index $i .`
5.done
Here iam not able to understand the porpose of the word "index" in line 4.
any help ?
cheers
RRK (3 Replies)
Discussion started by: ravi raj kumar
3 Replies
3. Filesystems, Disks and Memory
why do inode indices starts from 1 unlike array indexes which starts from 0
its a question from "the design of unix operating system" of maurice j bach
id be glad if i get to know the answer quickly
:) (0 Replies)
Discussion started by: sairamdevotee
0 Replies
4. UNIX for Dummies Questions & Answers
brothers why inode index starts from 1 unlike array inex which starts from 0
its a question from the design of unix operating system of maurice j.bach
i need to know the answer urgently...someone help please (1 Reply)
Discussion started by: sairamdevotee
1 Replies
5. Shell Programming and Scripting
Hi All,
I have a file (FileNames.txt) which contains the following data in it.
$ cat FileNames.txt
MYFILE17XXX208Sep191307.csv
MYFILE19XXX208Sep192124.csv
MYFILE20XXX208Sep192418.csv
MYFILE22XXX208Sep193234.csv
MYFILE21XXX208Sep193018.csv
MYFILE24XXX208Sep194053.csv... (5 Replies)
Discussion started by: krish_indus
5 Replies
6. UNIX for Dummies Questions & Answers
I have a line "My name is Deepak"
How can i search a string Deepak in the line and find out its index position.
Here in this case the result should be 12. (3 Replies)
Discussion started by: dr46014
3 Replies
7. Shell Programming and Scripting
1 2 000060000
How do i return the point in the string where the 6 is?
i.e what I want on output is
1 2 5
something like awk '{print $1 $2 index($3,6) }'
but I can't get it to work
Thanks in advance (3 Replies)
Discussion started by: garethsays
3 Replies
8. Shell Programming and Scripting
HI All,
I would like to pass a integer and get all values under this index the by using awk. Could anyone help?
Thanks :>
input:
1,2,3,4,5,6,7
1,2,3,48,5,6,7
1,2,3,4,5,6,7
e.g. i pass 4 to awk command
output:
4
48
4
Video tutorial on how to use code tags in The UNIX and Linux... (8 Replies)
Discussion started by: mimilaw
8 Replies
9. Shell Programming and Scripting
Hello Gents,
Please give a help with this case
Input
10001010G1
10001010G1
10001010G1
10001010G2
10001010G3
10001012G1
10001012G1
10001012G1
10001012G1
10001014G1
10001014G1
10001014G2 (5 Replies)
Discussion started by: jiam912
5 Replies
10. Shell Programming and Scripting
I am having data in XML format and trying to extract codes form two fields called <String>, below is the data.
<Node>tollfree<Condition>BooleanOperator<Operation>AND</Operation><Condition>BooleanOperator<Operation>NOT</Operation><Condition>FieldSelection<Field Context="ALL fields"... (7 Replies)
Discussion started by: rramkrishnas
7 Replies
LEARN ABOUT CENTOS
pmdapostgresql
PMDAPOSTGRESQL(1) Performance Co-Pilot PMDAPOSTGRESQL(1)
NAME
pmdapostgresql - PostgreSQL database PMDA
DESCRIPTION
pmdapostgresql is a Performance Co-Pilot PMDA which extracts live performance data from a running PostgreSQL database.
INSTALLATION
pmdapostgresql uses a configuration file from (in this order):
o /etc/pcpdbi.conf
o $PCP_PMDAS_DIR/postgresql/postgresql.conf
This file can contain overridden values (Perl code) for the settings listed at the start of pmdapostgresql.pl, namely:
o database name (see DBI(3) for details)
o database username
Once this is setup, you can access the names and values for the postgresql performance metrics by doing the following as root:
# cd $PCP_PMDAS_DIR/postgresql
# ./Install
If you want to undo the installation, do the following as root:
# cd $PCP_PMDAS_DIR/postgresql
# ./Remove
pmdapostgresql is launched by pmcd(1) and should never be executed directly. The Install and Remove scripts notify pmcd(1) when the agent
is installed or removed.
FILES
/etc/pcpdbi.conf
configuration file for all PCP database monitors
$PCP_PMDAS_DIR/postgresql/postgresql.conf
configuration file for pmdapostgresql
$PCP_PMDAS_DIR/postgresql/Install
installation script for the pmdapostgresql agent
$PCP_PMDAS_DIR/postgresql/Remove
undo installation script for the pmdapostgresql agent
$PCP_LOG_DIR/pmcd/postgresql.log
default log file for error messages from pmdapostgresql
SEE ALSO
pmcd(1), pmdadbping.pl(1) and DBI(3).
3.8.10 Performance Co-Pilot PMDAPOSTGRESQL(1)