[an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive]
[an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive]![]() |
![]() |
![]() |
|||||||||||||||||||||||||
|
|||||||||||||||||||||||||||
![]() |
![]() |
![]() |
Kim Schulz wrote: > On Mon, 16 Oct 2006 22:40:04 +0000 (UTC) > "Michael Rasmussen" <sslug@sslug> wrote: > >> Hvis du ser på hans diagrammer, er MySQL kun hurtigere, hvis du >> anvender MyISAM, og det er ikke en fair sammenligning. Du bør sammen >> ligne InnoDB og PostgresQL, og gør du det, vil du pludseligt se, at >> PostgresQL har væsentligt bedre performance. Tilføjer du hertil, at >> den forskel er exponentielt stigende med antallet af samtidige >> brugere - og især hvis det handler om opdatering, er der vist ikke >> den store tvivl tilbage:-) > > Nej det gjorde jeg nu ikke, men Postgres var sløv når vi indsatte > rigtigt mange rows samtidigt (100.000-1.000.00) imens vi > læste/skrev/opdaterede tabellerne. > Hellre slö än fel... bnl=# create table tmp (a int); CREATE TABLE bnl=# insert into tmp values (23); INSERT 0 1 bnl=# insert into tmp values (230000000000000000000); FEL: heltal utanför giltigt intervall bnl=# rollback; ROLLBACK bnl=# Jag tror inte mysql protesterar alls, utan glatt stoppar in int'last istället PostgreSQL blir snabb om man vårdar postmaster.conf. Den kommer default med värden som gör att pg går att starta på nästan alla maskiner, men inte med värden som gör att den går snabbt -- /Björn sslug@sslug
![]() |
![]() |
![]() |
||||||||||||
|
||||||||||||||
![]() | ||||||||||||||
|
||||||||||||||
![]() |
![]() |
![]() |