Strange problem

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

Browse pgsql-novice by date

  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