Hi Experts,
I've issue with the huge file.
My requirement is I need to search a pattern between the 155-156 position and if its match's to 31 or 36 then need to route that to a new separate files.
The main file has around 1459328 line and 2 GB in size. I tired with the below code which take around 2 hrs to execute.
Where as I modified this and used awk which is still taking more than 30 minutes but the results vary.
I even tired this too
but always the $5 wont come in between 155-156 position.
Sample records.
Do we have any other way in which I can get the currect results.
hey all, im new and my first question is:
say i have a word "blahblah"
how do i get and replace the last letter of the word with say k, so replace the h with a k.
However you cant just replace the h it has to change the LAST LETTER of the word.
Cheers In advance.
:b: (0 Replies)
Hi All
I am sorting a huge file
-rw-r--r-- 1 rama users 448156978 May 13 18:48 102384.temp
$ sort -k 1,40n 102384.temp > 102384.temp1
msgcnt 1468 vxfs: mesg 001: vx_nospace - /dev/vg00/var file system full (1 block extent)
sort: A write error occurred while sorting.
I thought... (3 Replies)
I have a file with data extracted, and need to insert a header with a constant string, say: H|PayerDataExtract
if i use sed, i have to redirect the output to a seperate file like
sed ' sed commands' ExtractDataFile.dat > ExtractDataFileWithHeader.dat
the same is true for awk
and... (10 Replies)
Hi ,
i have files coming in my system which are very huge in MB and GBs, all these files are in a single line, there is no newline character.
I need to get only last 700 bytes of these files, of this i am splitting the files by "split -b 700 filename" but this gives all the splitted... (2 Replies)
Hi i need to compare two fixed length files and produce the differences if any to a seperate file. I have to capture each and every differneces line by line. Ideally my files should not have any differences but if there are any then it should be captured without any miss. Also my files sizes are... (4 Replies)
Hi All,
I have two files as below:
file1 file2
AAAA CCCC,1234,0909
BBBBB AAAA,1234
AAAA DDDD,23536,9090
CCCC
DDDD
EEEEE
I want a out file as below
AAAA,1234
BBBB
AAAA,1234... (5 Replies)
Hi Experts,
I had to edit (a particular value) in header line of a very huge file so for that i wanted to search & replace a particular value on a file which was of 24 GB in Size. I managed to do it but it took long time to complete. Can anyone please tell me how can we do it in a optimised... (7 Replies)
Please help. My file system is 100%, I can't seem to find what is taking so much space. The total hard drive space is 150Gig free but I got nothing now.
I did to this to find the big file but it's taking so much time. Is there any other way?
du -ah / | more
find ./ -size +200M... (3 Replies)
Hi,
I have a Huge 7 GB file which has around 1 million records, i want to split this file into 4 files to contain around 250k messages each.
Please help me as Split command cannot work here as it might miss tags..
Format of the file is as below
<!--###### ###### START-->... (6 Replies)
I have big files (some are >300GB!) that need substitution for some patterns, for example, change Multiple Spaces into Tab. I used this oneliner:sed '1,18s/ \{1,\}/\t/g' infile_big.sam > outfile_big.sambut it seems very slow as the job is still running after 24 hours! In this example, only the... (8 Replies)
Discussion started by: yifangt
8 Replies
LEARN ABOUT CENTOS
load
LOAD(7) PostgreSQL 9.2.7 Documentation LOAD(7)NAME
LOAD - load a shared library file
SYNOPSIS
LOAD 'filename'
DESCRIPTION
This command loads a shared library file into the PostgreSQL server's address space. If the file has been loaded already, the command does
nothing. Shared library files that contain C functions are automatically loaded whenever one of their functions is called. Therefore, an
explicit LOAD is usually only needed to load a library that modifies the server's behavior through "hooks" rather than providing a set of
functions.
The file name is specified in the same way as for shared library names in CREATE FUNCTION (CREATE_FUNCTION(7)); in particular, one can rely
on a search path and automatic addition of the system's standard shared library file name extension. See Section 35.9, "C-Language
Functions", in the documentation for more information on this topic.
Non-superusers can only apply LOAD to library files located in $libdir/plugins/ -- the specified filename must begin with exactly that
string. (It is the database administrator's responsibility to ensure that only "safe" libraries are installed there.)
COMPATIBILITY
LOAD is a PostgreSQL extension.
SEE ALSO
CREATE FUNCTION (CREATE_FUNCTION(7))
PostgreSQL 9.2.7 2014-02-17 LOAD(7)