Michael Fuhr wrote: > That's a tenuous conclusion; it assumes that the data transfer is
Are you trying to say that data won't be compressed ? > what's taking all the time. Query planning and execution and > client-side processing must also be taken into account. Using a > sniffer to observe the amount of data transferred would be a more > appropriate test. > >From client connection: EXPLAIN SELECT sfi,nvi,jmi FROM articles ORDER BY sif; QUERY PLAN ------------------------------------------------------------------------------------ Index Scan using articles_pkey on articles (cost=0.00..1031.61 rows=12410 width=42) (1 row) So it returns 12410 rows : sfi = INTEGER, nvi = varchar(50), jmi = varchar(3). Yes, I know that my conclusions are tenuous, but what to say when both tests returns result in approx. amount of time (compressed or not). Using compression on my nTier (kbmMW (ZLIB) ) same query returns in 9 seconds (!=20 secs !). (same client, same server , same query). cheers, zac ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq