Dave Lazar wrote:
Hi,
I have a table with 10 rows, and about 50 columns. Not much need for
indexing. When I execute a select * command, it can take 18ms to run
the query, but 1300ms for the data retrieval time for example...
What controls this data retrieval timing? It seems like my query
executes fast, but the bottleneck is this value?? Is there something
in postgresql.conf that needs tweaking. I have a RH box with a 17Ghz
P4 and 2 gigs RAM, and the bottleneck pgAdmin shows me appears to be
this data retrieval time.
It's the GUI that takes up the time, i.e. the client, 18ms is postgresql
backend and transport time, nothing to be tuned in postgresql.conf here.
You're probably running pgAdmin on Linux, where the wxgtk implementation
of wxListView is really slow with a lot of columns.
Regards,
Andeas
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
