From: | Tim Sailer <tps(at)unslept(dot)com> |
---|---|
To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Strange problem |
Date: | 2016-02-11 17:27:57 |
Message-ID: | 56BCC49D.2010101@unslept.com |
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
Tim
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Sailer | 2016-02-11 17:30:48 | Strange Problem |
Previous Message | Shmagi Kavtaradze | 2016-02-09 15:42:17 | Similarity check on vectors |