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
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
#x27;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
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 w
ctional behavior within the session.
regards, tom lane
--
Grigory Smolkin
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
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
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
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 writes:
I was trying to create a parallel aggregate with base_type parameter and
failed
postgres=# CREATE AGGREGATE ST_Extent_parallel
