256M of ram, but there is a lot of other
things running on.
The main things about database is the hard drive speed, with the turtle
I've got in this server, it is *slow*, just get a scsi3 hard drive and
it'll run like smoothly, the second thing, is the memory/cpu speed, but it
really
E: QUERY PLAN:
Index Scan using file_pkey on file (cost=0.00..3.18 rows=1 width=117)
(actual time=0.60..0.61 rows=1 loops=1)
Total runtime: 0.77 msec
and it's an old poor :
hda: IBM-DTLA-307030, ATA DISK drive
ps: the select count(*) took a long time, but I believe that
nks in advance!
well, I had a 7.1.3 database, and I switched over to 7.2 without oids,
here's the change :
7.1.3 :
4367448 /opt/pg/data/base/18721
7.2 :
3551340 /opt/pgsql/data/base/16567
and there's a bit more info in the 7.2 database now...
so I believe that without oids give yo
the field indexed is Varchar(16). The table indexed contains 20
> MO of rows.
what's the difference between b-tree and hashed indexes ?
--
Mathieu Arnold
trust
host all 127.0.0.1 255.255.255.255 trust
try something like :
localall crypt
host all 127.0.0.1 255.255.255.255 crypt
--
Mathieu Arnold
p.
>
> Mike
> [EMAIL PROTECTED]
>
> - Original Message -
> From: Mathieu Arnold <[EMAIL PROTECTED]>
> To: Mike Field <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Thursday, July 06, 2000 9:49 AM
> Subject: Re: [ADMIN] Postmaster crashes
the help.
>
> Thanks,
>
> Mike
> [EMAIL PROTECTED]
--
Mathieu Arnold
