Postgres 8.4.9 on CentOS
I partitioned some tables over the weekend by month using a date field as the
partitioning column. Table inheritance was used and all indexes on the parent
were created on the partitions. constraint_exclustion = partition.
My question is, are partitions really
Postgres 8.4.9 on CentOS
I partitioned some tables over the weekend by month using a date field as
the partitioning column. Table inheritance was used and all indexes on the
parent were created on the partitions. constraint_exclustion = partition.
My question is, are partitions really gett
Updating: I found two other sessions running the same query. Once I killed them
the pg_tmp files were automatically deleted.
>>
This morning we found out that our filesystem was at 98% and filling quickly.
We immediately found one query running for a long time and saw 1500+ files in
the pg
, February 05, 2013 12:07 PM
To: Robert Klaus
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] cleanup of pgsql_tmp directory
"Robert Klaus" writes:
> This morning we found out that our filesystem was at 98% and filling
> quickly. We immediately found one query running for
This morning we found out that our filesystem was at 98% and filling
quickly. We immediately found one query running for a long time and saw
1500+ files in the pgsql_tmp directory we could attribute to it.
I killed using pg_terminate_backend and some space was reclaimed, but the
temporary f
, 2013 11:31 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Large number of rows in pg_type and slow gui
(pgadmin) refresh
Robert Klaus wrote on 03.01.2013 16:50:
> We have 36,000+ rows returned by " SELECT oid, format_type(oid,
> typtypmod) AS typname FROM pg_type".
>
We have 36,000+ rows returned by " SELECT oid, format_type(oid, typtypmod)
AS typname FROM pg_type".
My manager says this is only a small number compared to what is expected by
next summer.
When I run this select statement on the database server it returns in under
1 second but it takes a m
