MirrorX wrote: > default_statistics_target is set to (default) 100 and there no > special statistics per-column > in absolute units i can see the same query having similar stats to > these: > parse -> 600 ms > bind -> 300 ms > execute -> 50 ms How did you determine those timings? > the query mentioned above is a simple select from one table using > using two where conditions. and this table has 1 additional index > (except the primary key) on the columns that are part of the where > clause Are you saying that a simple query against a single table with only two indexes is taking 600 ms to plan and 300 ms to bind? I have never seen anything remotely like that. Could you post the psql \d output for the table and the actual query? It would also be good to include a description of the hardware and the output of running the query on this page: http://wiki.postgresql.org/wiki/Server_Configuration -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
