Re: [PERFORM] query slows down drastically with increased number of

2006-10-26 Thread Tom Darci
ot6_tdarci=# select p.opid || p.opid || p.opid || p.opid || p.opid || p.opid || p.opid || p.opid || p.opid || p.opid from ott_op p; Time: 672.113 ms -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Thursday, October 26, 2006 2:53 PM To: Tom Darci Cc: pgsql-performance

[PERFORM] query slows down drastically with increased number of fields

2006-10-26 Thread Tom Darci
Hello All-     We have a question about numbers of fields in the select clause of a query and how that affects query speed.   The following query simply selects the primary key field from a table with 100,000 records:   select p.