Re: [HACKERS] [GENERAL] Cast your vote ...

[Charles H. Woloszynski]

Yeah, the registration was painless and enough options to disable it 
annoying you. Count my vote cast for PostgreSQL.  I encourage everyone 
else to do the same.  In the big picture, marketing statements like this 
survey mean alot more than most technical folks want to acknowledge.  

Please vote for your favorite database.

Charlie


Peter Childs wrote:

On Thu, 2 Jan 2003, Marc G. Fournier wrote:

 

Just got this in my mailbox:

2002 LinuxQuestions.org Members Choice Awards:

http://www.linuxquestions.org/questions/showthread.php?s=78a8c06fbc1dcecd52597decd6c56ad8threadid=39870

And we are way behind MySQL (like, d'ah!):

http://www.linuxquestions.org/questions/poll.php?s=78a8c06fbc1dcecd52597decd6c56ad8action=showresultspollid=168

The problem, of course, is that you have to be a registered member to
vote, so its not an 'open poll' ...


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

   


	Open Poll? Its free to register, so really its to try and stop 
people voting twice. They don't even want that much data just your E-Mail 
address. (The rest is optional)
	The problem with Web Polls is that people can always vote more 
than once making any result totally meaning less what ever you do. 
Ensuring an election is anoumous, free and fare is VERY difficult.

Peter Childs


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
   (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
 


--


Charles H. Woloszynski

ClearMetrix, Inc.
115 Research Drive
Bethlehem, PA 18015

tel: 610-419-2210 x400
fax: 240-371-3256
web: www.clearmetrix.com






---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Re: [HACKERS] [GENERAL] Large databases, performance

[Charles H. Woloszynski]

  
   
Inserts + building a composite index   
300MB data, 3,000,000 tuples,28 secs 130 
secs150 secs
about 100 bytes each, schema on 
'schema' sheet
composite index on 3 fields 
(esn, min, datetime)  
   
Select Query   7 secs  7 secs 
 6 secs
based on equality match of 2 fields
(esn and min) - 4 concurrent queries 
running
   
Database Size on Disk  341 MB  619 MB 
 788 MB
  



Field Name Field Type  NullableIndexed
type   int no  no
esnchar (10)   no  yes
minchar (10)   no  yes
datetime   timestamp   no  yes
opc0   char (3)no  no
opc1   char (3)no  no
opc2   char (3)no  no
dpc0   char (3)no  no
dpc1   char (3)no  no
dpc2   char (3)no  no
npachar (3)no  no
nxxchar (3)no  no
rest   char (4)no  no
field0 int yes no
field1 char (4)yes no
field2 int yes no
field3 char (4)yes no
field4 int yes no
field5 char (4)yes no
field6 int yes no
field7 char (4)yes no
field8 int yes no
field9 char (4)yes no

  




---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
  


-- 


Charles H. Woloszynski

ClearMetrix, Inc.
115 Research Drive
Bethlehem, PA 18015

tel: 610-419-2210 x400
fax: 240-371-3256
web: www.clearmetrix.com





---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html