[users] Re: [newpkgs] New PostgreSQL packages

[Daniel Seichter]

Hello Mark,

thank you for your detailed answer. If I can finish my project I need a
server which can handle big data volumes and handle many subqueries
(like postgresql). And SUN advertises for the Opteron (but I don't think
if this is a REAL 64bit engine, beccause of the compatibility of x86
code) but maybe it will be a server with this technology and so I can
test it in real "life".
On my Blade 1500 I can't really compare if it is faster, because there
is a ATA Hard-Disk.

But hope to get a real test soon.

Wish you a nice evening

Daniel Seichter

P.S.: Maybe you are interested in another environment for postgresql:
postgresql.dseichter.org (not actual but will be soon)



On Thu, 18 Mar 2004 10:50:40 +0000
Mark Round <mark at markround.com> wrote:

> Daniel Seichter wrote:
> 
>  >Hello Mark,
>  >
>  >thank you for your answer. My database is at the moment about 3GB
>  >and only contains text. Is there a size of database where 64bit
>  >results a higher performancel than 32bit?
>  >
>  >Thanks
>  >Daniel
>  >
> 
> Hi!
> Sorry for the delay in responding, I've been doing some digging
> around, to see what I could find.
> I've never myself run a database of that size, so it's hard for me to 
> say - the only way you'll ever really be
> sure is to do some benchmarking yourself, comparing the performance of
> the two servers. However,
> I did find the following which seems to answer your question - the cut
> off point seems to be around the
> 5Gb mark (assuming you trust someone anecdotal evidence...)  :-
> 
> "Performance of 32-bit cpu machines will decline rapidly when the 
> database size
> exceeds 5 GigaByte. You can run 30 gig database on 32-bit cpu but the 
> performance
> will be degraded. Machines with 32-bit cpu impose a limitation of 2 GB
> on RAM,
> 2 GB on file system sizes and other limitations on the operating
> system....
> For extremely large databases, it is strongly advised to use 64-bit 
> machines  
> Compile PostgreSQL under a 64-bit cpu and it can support huge
> databases and large queries.
> ...
> Performance of PostgreSQL for queries on large tables and databases
> will be several times faster than PostgreSQL on 32-bit cpu machines.
> Advantage of 64-bit
> machines are that you get very large memory addressing space and the 
> operating
> system can support very large file-systems, provide better performance
> with large databases, support much larger memory (RAM), have more 
> capabilities etc..
> "
> 
> (Taken from 
> http://www.collaborium.org/onsite/venezuela/docs/linux/Linux_HOWTOS/PDF/PostgreSQL-HOWTO.pdf)
> 
> -Mark
> _______________________________________________
> users mailing list
> users at lists.blastwave.org
> https://lists.blastwave.org/mailman/listinfo/users