Is there any possibility to change datatype of a
field.
regards,
S Baskar
Hi Sreedhar,
There are no commands as such but
combination of CREATE TABLE AS SELECT f1,f2 from TAB
and CAST might prove useful in certain cases
regds
mallah.
On Saturday 25 May 2002 12:22 pm, shreedhar wrote:
Is there any possibility to change datatype of a field.
regards,
S Baskar
--
On Fri, 2002-05-24 at 15:58, Kris Deugau wrote:
Rajesh Kumar Mallah. wrote:
I am setting up a new database server.
the data is critical that is why i am thniking
to mirror the SCSI disks in RAID 1 configuration.
I do not have a hardware raid controller.
If it's that critical, you
I have this query:
select c.cod_cliente, c.controle, c.dt_vencimento,
c.dt_emissao, c.nro_doc_banco, c.nro_documento, c.recebido, c.ref_cidade,
c.valor, (select u.username from ctareceber c left join username u on
u.id=c.cod_cliente limit 1) as fldusername, p.id, p.nome, a.id, a.nome from
If I was in your situation I would put both 18's into a sw raid 1
configuration. You may lose some speed on the writes since it's doing more
work than writing to 1 disk but the redundancy will be well worth it should
the day come when you need it.
-Original Message-
From: [EMAIL
Tom Lane writes:
Is there any rhyme or reason to the various RAID n designations?
Or were they just invented on the spur of the moment?
The paper that introduced the term RAID used a numerical classification
for the various schemes. (So I guess the answer is yes.) The traditional
levels
On Sat, May 25, 2002 at 09:29:01PM +0200, Peter Eisentraut wrote:
0 Nonredundant
1 Mirrored
2 Memory-style ECC
3 Bit-interleaved parity
4 Block-interleaved parity
5 Block-interleaved distributed parity
[Hennessy Patterson]
There are also other levels. One poster talked about
adding my $0.02
JBOD : just a bunch of disks, not raid in my opinion
Raid 0 : striping over disks, no redundancy, hence the Redundancy in
Redundant Arrays of Independent Disks is zero.
Raid 1 : Mirroring, full redundancy, Redundancy 1(00%)
Raid 4: see thread
Raid 5: see thread,Striping across
On Fri, 24 May 2002, Rajesh Kumar Mallah. wrote:
I am setting up a new database server.
the data is critical that is why i am thniking
to mirror the SCSI disks in RAID 1 configuration.
I do not have a hardware raid controller.
could anyone give me some pointer , or suggest me
if its
On Sat, May 25, 2002 at 12:45:12PM -0700, Fred Moyer wrote:
Performance (fastest-slowest)
hardware raid - software raid
raid 0 - 10 - 1 - 5
Redundancy (most - least)
hardware raid - software raid
10, 1 - 5 - 0
It's really not possible to compare RAID-levels
10 matches
Mail list logo