Re: [GENERAL] Сreate parallel aggregate

2016-09-29 Thread Grigory Smolkin
Thank you for the detailed answer. I think a less obscure error message would be a good thing. On 09/29/2016 05:26 PM, Tom Lane wrote: Grigory Smolkin <g.smol...@postgrespro.ru> writes: I was trying to create a parallel aggregate with base_type parameter and failed postgres=# CREATE AGG

[GENERAL] Сreate parallel aggregate

2016-09-29 Thread Grigory Smolkin
ombineBBox, finalfunc = box2d, stype = box3d, parallel = safe ); CREATE AGGREGATE Is that a bug or a feature? -- Grigory Smolkin Postgres Professional: http://www.postgrespro.com The Russian Postgres Company

Re: [GENERAL] fun fact about temp tables

2016-08-05 Thread Grigory Smolkin
On 08/05/2016 07:18 PM, Andrew Sullivan wrote: On Fri, Aug 05, 2016 at 06:02:08PM +0300, Grigory Smolkin wrote: But it`s temporary table so it`s equal to saying 'I don`t care about this data' and I can get 'out of disk space' regardless of using temporary tables. What are we winning here

Re: [GENERAL] fun fact about temp tables

2016-08-05 Thread Grigory Smolkin
mal transactional behavior within the session. regards, tom lane -- Grigory Smolkin Postgres Professional: http://www.postgrespro.com The Russian Postgres Company

Re: [GENERAL] fun fact about temp tables

2016-08-05 Thread Grigory Smolkin
Thank you for your answer. But it`s temporary table so it`s equal to saying 'I don`t care about this data' and I can get 'out of disk space' regardless of using temporary tables. What are we winning here? On 08/05/2016 05:51 PM, Tom Lane wrote: Grigory Smolkin <g.smol...@postgrespro

[GENERAL] fun fact about temp tables

2016-08-05 Thread Grigory Smolkin
t')); pg_size_pretty 64 kB (1 row) Postgres filling relation file with nulls page by page. Isn`t that just kind of killing the whole idea of temp tables? -- Grigory Smolkin Postgres Professional: http://www.postgrespro.com The Russian Postgres Company

Re: [GENERAL] files in database directory

2016-08-02 Thread Grigory Smolkin
On 08/02/2016 04:51 PM, Adrian Klaver wrote: On 08/02/2016 06:44 AM, Grigory Smolkin wrote: Hello, everyone! I found some files in postgresql database directory: t13_14363083 t13_14363081 t13_14363098 Some of them are quite old. Can someone explain their purpose? https

[GENERAL] files in database directory

2016-08-02 Thread Grigory Smolkin
Hello, everyone! I found some files in postgresql database directory: t13_14363083 t13_14363081 t13_14363098 Some of them are quite old. Can someone explain their purpose? -- Grigory Smolkin Postgres Professional: http://www.postgrespro.com The Russian Postgres Company