[GENERAL] PG-upgrade : 7.0.3 -> 7.1.2

2001-06-22 Thread Svenne Krap
Hi, I administer an quite important PGsql v. 7.0.3 installation... We would very much like to upgrade, BUT we cannot afford to be offline for a very long period .. half an hour is acceptable. I have tried to install the new one under a new location and have done an init-db.. both are running

[GENERAL] Speed...

2001-06-22 Thread Svenne Krap
Hi again, I have been following this list for approx. 6600 messages (i think that is 2 months or so.. .) - an yes.. Like the Cardassian Order I keep everything :) A couple of time, ppl has been talking about speed.. What about a couple of benchmarks from your systems, so that us newbies (or

[GENERAL] explain, planner and more..

2001-08-14 Thread Svenne Krap
Hi, how has the following to be read.. (ie. what is the total cost of the query)... 4.05, 5.88 or ? Why does the planner choose not to use numberdomain_pkey as index on numberdomain ? The table layout is quite bad (due to a lot of last minute-changes) # explain select c.*, (select count(*) f

[GENERAL] PGSQL & java applets

2001-10-13 Thread Svenne Krap
Hi, Is it possible to use pgsql in java-applets. If it is, any skeleton app woudl be greatly appriciated... /Svenne -- Mail [EMAIL PROTECTED] - [EMAIL PROTECTED] - PGP key id : 0xDF484022 ICQ: 5434480 - http://www.krap.dk - http://www.krap.net PGP Key http://keys.pgp.dk:11371/pks/lookup?op=