[PERFORM] Query 200x slower on server [PART 2]

See Query 200x slower on server [PART 1] before reading any further QUERY PLAN ON MY HOME SERVER Sort (cost=1516.55..1516.59 rows=15 width=640) (actual time=123.008..123.435 rows=1103 loops=1) Sort Key: aanmaakdatum - Subquery Scan producttabel (cost=1515.39..1516.26 rows=15 width=640)

Re: [PERFORM] database model tshirt sizes

', quantity: 0 productid: 345, versionid: 3, color: null, size: 'pc', quantity: 5 productid: 345, versionid: 3, color: null, size: 'playstation', quantity: 3 ALSO: what is versionid used for? - Original Message - From: [EMAIL PROTECTED] To: NbForYou [EMAIL PROTECTED] Cc: pgsql-performance

[PERFORM] database model tshirt sizes

Hello, Does anybody know how to build a database model to include sizes for rings, tshirts, etc? the current database is built like: table product = productid int8 PK productname charvar(255) quantity int4 what i want now is that WHEN (not all products have multiple sizes)

Re: [PERFORM] Process Time X200

. And running a webhosting service is a commercial use. thanks for replying and going through the effort of creating the database and populating it. Nick - Original Message - From: Michael Fuhr [EMAIL PROTECTED] To: NbForYou [EMAIL PROTECTED] Cc: pgsql-performance@postgresql.org Sent

Re: [PERFORM] Process Time X200

however that this information is accurate... I thank everybody who have responded so far. Great feedback! - Original Message - From: Richard Huxton dev@archonet.com To: NbForYou [EMAIL PROTECTED] Cc: Michael Fuhr [EMAIL PROTECTED]; pgsql-performance@postgresql.org Sent: Friday, March 10

[PERFORM] Process Time X200

Hello, I could need some help. I have a Postgresql databaseWhen i do a query on my homeserver the result is given back fast but when i do the same query on my webhost server the query is useless because of the processtime (200 times slower (56366.20 / 281.000 = 200.59) ). My Pc is just a