From: | Tim Sailer <tps(at)unslept(dot)org> |
---|---|
To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Strange Problem |
Date: | 2016-02-11 17:30:48 |
Message-ID: | 56BCC548.5060204@unslept.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I have an application that parses web server log files, and inserts a
few million rows into a table each month, one table per month. Lately,
I've been getting reports that there is no recent data, so I went
looking. I'll concentrate on the first table that seems to have an
issue because there are a few, all seemingly the same. \dt+ shows the
table size of 6463 MB. OK, there's data there. "select count(*) from
table" comes back with 0; "select ctid from table" comes back with 0,
but after a while. pg_dump or pg_dumpall completely skip the table.
I'm not a complete novice, but I'm stumped. No errors in the OS system
logs, postgres starts and stops with no errors. This is running on
ubuntu 14.04.03, with postgres 9.3
From | Date | Subject | |
---|---|---|---|
Next Message | Thom Brown | 2016-02-11 17:39:52 | Re: Strange Problem |
Previous Message | Tim Sailer | 2016-02-11 17:27:57 | Strange problem |