On 26/07/10 17:25, Vitalii Tymchyshyn wrote: > 26.07.10 12:15, Craig Ringer написав(ла): >> On 26/07/10 16:35, Piotr Gasidło wrote: >> >>> Hello, >>> >>> I've found strange problem in my database (8.4.4, but also 9.0beta3, >>> default postgresql.conf, shared_buffers raised to 256MB). >>> >>> EXPLAIN ANALYZE SELECT ... >>> Total runtime: 4.782 ms >>> Time: 25,970 ms >> Given that, I'm wondering if the difference in this case is planning >> time. I can't really imagine the query planner taking 20 seconds (!!) to >> run, though, no matter how horrifyingly complicated the query and table >> structure were, unless there was something going wrong. >> > Actually it's 20ms, so I suspect your point about planning time is correct. Oh, a commas-as-fraction-separator locale. That makes sense. Thanks for the catch. -- Craig Ringer -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
