10-08-2005
please follow the rules and write your question in english again (anyway , this sentence makes no sense, this is not german, just a mix of german words
i don't understand this even if the forum rules would allow to write in german
)
gP
10 More Discussions You Might Find Interesting
1. Programming
how can i display the ammount of Memory a Process used or allocated with *alloc?
Lazzar (1 Reply)
Discussion started by: Lazzar
1 Replies
2. UNIX for Dummies Questions & Answers
Hello All.
I have problem archiving files.
The problem is:)
I have about 10000 files in one directory, all this file aproximately the same size, i need to gzip them and write on DVD. But all this files take about 15 GB of space (already gzipped). So i need DVD Blue-Ray :p or i need to split... (3 Replies)
Discussion started by: Maxeg
3 Replies
3. Solaris
Hi,
Im working on Solaris 9 on SPARC-32 bit running on an Ultra-80, and I have to find out the following:-
1. Total Physical Memory in the system(total RAM).
2. Available Physical Memory(i.e. RAM Usage)
3. Total (Logical) Memory in the system
4. Available (Logical) Memory.
I know... (4 Replies)
Discussion started by: 0ktalmagik
4 Replies
4. Programming
Hi,
I'm trying to learn how to manage memory when I have to deal with lots of data.
Basically I'm indexing a huge file (5GB, but it can be bigger), by creating tables that
holds offset <-> startOfSomeData information. Currently I'm mapping the whole file at
once (yep!) but of course the... (1 Reply)
Discussion started by: emitrax
1 Replies
5. Solaris
Is it possible to restrict physical memory in solaris zone with zone.max-locked-memory just like we can do with rcapd ? I do not want to used rcapd (1 Reply)
Discussion started by: fugitive
1 Replies
6. Programming
In a 'C' program,when I am trying to allocate memory with the help of malloc () function, it is allocating the memory up to a certain limit for e.g. in my case, it is 670 MB (approx). malloc() returns NULL if I allocate more than this amount of memory.When I tried
to allocate memory in chunks of... (1 Reply)
Discussion started by: vipinsachan
1 Replies
7. Shell Programming and Scripting
Hey, I'm kinda new to the shell scripting and I don't wanna mess things up yet :)
Looking for a solution to the following:
I need to move all the files like "filename.failed.dateandtime" to another directory also renaming them "filename.ready". I can't figure how to do this with multiple files... (4 Replies)
Discussion started by: sg3
4 Replies
8. Solaris
Hi Experts,
Our servers running Solaris 10 with SAP Application. The memory utilization always >90%, but the process on SAP is too less even nothing.
Why memory utilization on solaris always looks high?
I have statement about memory on solaris, is this true:
Memory in solaris is used for... (4 Replies)
Discussion started by: edydsuranta
4 Replies
9. Filesystems, Disks and Memory
Hi,
i have just installed 4 gb RAM ddr3 on OS Windows 7 32 bit.
In "manage peripherals" i see this section:
Memory installed (ram) : 4,00 gb (2,30gb usable)
Why only 2,30 gb usable ?
In Windows 7 32bit the maximum size is not 3,00gb ?
see file attached, please (4 Replies)
Discussion started by: nash83
4 Replies
10. UNIX for Dummies Questions & Answers
Hi,
I have as Solaris 10 (x86) system. I want to set the maximum memory for the user
But the following comaand is valid only till next reboot.Pls let me know how to make it permanenent.
prctl -n project.max-shm-memory -r -v 4G -i project 3 (6 Replies)
Discussion started by: Rossdba
6 Replies
LEARN ABOUT CENTOS
create_collation
CREATE
COLLATION(7) PostgreSQL 9.2.7 Documentation CREATE COLLATION(7)
NAME
CREATE_COLLATION - define a new collation
SYNOPSIS
CREATE COLLATION name (
[ LOCALE = locale, ]
[ LC_COLLATE = lc_collate, ]
[ LC_CTYPE = lc_ctype ]
)
CREATE COLLATION name FROM existing_collation
DESCRIPTION
CREATE COLLATION defines a new collation using the specified operating system locale settings, or by copying an existing collation.
To be able to create a collation, you must have CREATE privilege on the destination schema.
PARAMETERS
name
The name of the collation. The collation name can be schema-qualified. If it is not, the collation is defined in the current schema.
The collation name must be unique within that schema. (The system catalogs can contain collations with the same name for other
encodings, but these are ignored if the database encoding does not match.)
locale
This is a shortcut for setting LC_COLLATE and LC_CTYPE at once. If you specify this, you cannot specify either of those parameters.
lc_collate
Use the specified operating system locale for the LC_COLLATE locale category. The locale must be applicable to the current database
encoding. (See CREATE DATABASE (CREATE_DATABASE(7)) for the precise rules.)
lc_ctype
Use the specified operating system locale for the LC_CTYPE locale category. The locale must be applicable to the current database
encoding. (See CREATE DATABASE (CREATE_DATABASE(7)) for the precise rules.)
existing_collation
The name of an existing collation to copy. The new collation will have the same properties as the existing one, but it will be an
independent object.
NOTES
Use DROP COLLATION to remove user-defined collations.
See Section 22.2, "Collation Support", in the documentation for more information about collation support in PostgreSQL.
EXAMPLES
To create a collation from the operating system locale fr_FR.utf8 (assuming the current database encoding is UTF8):
CREATE COLLATION french (LOCALE = 'fr_FR.utf8');
To create a collation from an existing collation:
CREATE COLLATION german FROM "de_DE";
This can be convenient to be able to use operating-system-independent collation names in applications.
COMPATIBILITY
There is a CREATE COLLATION statement in the SQL standard, but it is limited to copying an existing collation. The syntax to create a new
collation is a PostgreSQL extension.
SEE ALSO
ALTER COLLATION (ALTER_COLLATION(7)), DROP COLLATION (DROP_COLLATION(7))
PostgreSQL 9.2.7 2014-02-17 CREATE COLLATION(7)