From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | sthomas(at)cise(dot)ufl(dot)edu (Shiby Thomas) |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] postgres performance |
Date: | 1998-01-15 18:23:07 |
Message-ID: | 199801151823.NAA03378@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>
> Hi,
>
> I have installed PostgreSQL6.2.1 from my own user account (I was just trying
> to test out something first). It seems to be running too slow. For example,
> the self join of a table with roughly 300K records takes 2-3 hours. There is
> an index on the join attribute.
> I am running it on a 8 processor (each is a 248 MHz SUNW,UltraSPARC-II)
> machine with a total of 2.0 GB main memory.
> But, since it is not parallelized, it may get the power of only one processor.
You said a self-join. I think we have a performance problem there.
Vadim?
>
> Does it make a difference in performance since I have installed it from my
> user account, and not the root. Also, I compiled it using gcc on a
> solaris 2.5 machine and the machine I ran it is a solaris 2.6 machine. I did
> that since the solaris 2.6 machine is the fastest we have here and the
> executable
> compiled on 2.5 was running properly also. Can that have an impact on the
> performance?
>
> Thanks
> --shiby
>
>
>
--
Bruce Momjian
maillist(at)candle(dot)pha(dot)pa(dot)us
From | Date | Subject | |
---|---|---|---|
Next Message | Shiby Thomas | 1998-01-15 18:33:08 | Re: [HACKERS] postgres performance |
Previous Message | The Hermit Hacker | 1998-01-15 18:15:59 | Re: [HACKERS] postgres performance |