27.07.10 02:03, Lew написав(ла):
Piotr Gasidło wrote:
EXPLAIN ANALYZE SELECT ...
Total runtime: 4.782 ms
Time: 25,970 ms
Strangely, the runtime is shown with a period for the separator, though.
One value is calculated on server by EXPLAIN ANALYZE command, another is
calculated by psql itself
Piotr Gasidło wrote:
EXPLAIN ANALYZE SELECT ...
Total runtime: 4.782 ms
Time: 25,970 ms
Vitalii Tymchyshyn wrote:
Actually it's 20ms, so I suspect your point about planning time is correct.
Craig Ringer wrote:
Oh, a commas-as-fraction-separator locale.
That makes sense. Thanks for the catc
=?UTF-8?Q?Piotr_Gasid=C5=82o?= writes:
> Ok. Is there any way to tune postgresql, to shorten planning time for
> such queries?
You've got a ridiculously large number of partitions. Use fewer.
regards, tom lane
--
Sent via pgsql-performance mailing list (pgsql-performan
2010/7/26 Vitalii Tymchyshyn :
> 26.07.10 12:15, Craig Ringer написав(ла):
> (...)
> Piotr: You can try preparing your statement and then analyzing execute time
> to check if this is planning time.
You are right.
I've done simple PREPARE (without params, etc).
> REPARE query as select oc_h_id,oc
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).
>>>
>>> EXP
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
SELECT
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
>
> SELECT ...
> ...
> (21 rows)
>
> T
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
SELECT ...
...
(21 rows)
Time: 23,042 ms
Test done in psql connected by socket to server (sam