[10:52] <mugwump> VARCHAR(255) / VARCHAR(2048) / TEXT
[10:53] <mugwump> Pg 7.4, amd64
[10:53] <mugwump> no indexes
[10:53] <mugwump> test.pl: Ok, type = varchar(255), took 91.3s
[10:53] <Shiny> mugwump: you're a varchar
[10:53] <mugwump> 1_000_000 rows
[10:55] <mugwump> test.pl: Ok, type = varchar(2048), took 92.9s
[10:55] <Shiny> ooo.. new frank black
[10:55] <mugwump> !NO MORE BETS!
[10:55] * Mjollnir` waits for TEXT
[10:56] <gargi_bot> text's karma score is 1
[10:56] <mugwump> test.pl: Ok, type = text, took 91.4s
[10:56] <waawaa> lol
[10:56] <IkeKrull> <gasp>
[10:56] <Shiny> so, shorter varchars do better
[10:57] <waawaa> pfft, it's within margin of error
[10:57] <Mjollnir`> what was it doing ?
[10:57] <mugwump> the results were 0.1s different over 1_000_000 inserts! :)
[10:57] <mugwump> inserting values between 1 and 100 chars long
[10:57] <mugwump> 100 per commit
[10:57] <mugwump> no indexes
Other related posts:
are you an internet addict?
find technical women to speak at your events- geekspeakr.com keeps growing
Some useful twitter sites
Add a comment
Please note: comments that are inappropriate or promotional in nature will be deleted.
E-mail addresses are not displayed, but you must enter a valid e-mail address to confirm your comments.
Are you a registered Geekzone user? Login to have the fields below automatically filled in for you and to enable links in comments. If you have (or qualify to have) a Geekzone Blog then your comment will be automatically confirmed and shown in this blog post.