Hello Everybody,
This is the scenario:
I have a postgres 8.4, debian packages installed from pgdg repository
and version equal to: 8.4.21-1.pgdg70+1
I have a GPS database that insert about 4 million records on some tables
every week, the database is partitioned per week, I do a manual vacuum
eve
= '2014-11-11 23:00:00-05'::timestamp with time
zone) AND (event_system_time <= '2014-11-17
00:59:59.99-05'::timestamp with time zone))
-> Seq Scan on
device_distance_2014w46 dev (cost=0.00..1615.54 rows=57730 width=4)
Filter:
((event_system_time >= '2014-11-11 23:00:00-05'::timestamp with time
zone) AND (event_system_time <= '2014-11-17
00:59:59.99-05'::timestamp with time zone))
-> Seq Scan on
device_distance_2014w47 dev (cost=0.00..1728.36 rows=1 width=4)
Filter:
((event_system_time >= '2014-11-11 23:00:00-05'::timestamp with time
zone) AND (event_system_time <= '2014-11-17
00:59:59.99-05'::timestamp with time zone))
(77 rows)
--
Typed on my key64.org keyboard
Nestor A Diaz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
_id = ev.id
WHERE TRUE )
SELECT *
FROM x
ORDER BY x.x_event_time ,
x.x_system_time ;
>
> Well this is coming from the kernel OOM(Out Of Memory) manager.
>
> For how to deal with this see here:
>
> http://www.postgresql.org/docs/8.4/static/kernel-resources.html#AEN24213
21339, comm:
postgres Tainted: G O 3.2.0-4-amd64 #1 Debian 3.2.63-2+deb7u1
Any ideas on how to fix the creation of too much files under 'pgsql_tmp'
directory ? Any hint on the Out of memory error ?
Slds.
--
Nestor A Diaz
--
Sent via pgsql-general mailing list (pgsql-gener
m verbose public.tablename;
if finish immediately, but if I do:
# vacuum analyze verbose public.tablename;
it takes forever, it seems it analyze every child table.
So for now is just a matter of removing vacuum for the master table and
then doing it manually every night I guess.
Nestor A. Diaz wro
ecipe ?
How do I check when I am near the limit of the transaction ID ?
Do I need to vacuum tables that haven't change a long time ago ?
Anybody have experienced the same behavior and would like to comment on
this ?
Slds.
--
Nestor A. Diaz
--
Sent via pgsql-general mailing
