| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Tom Spencer <tspencer9(at)gmail(dot)com> |
| Cc: | pgsql general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Date/time of last commit |
| Date: | 2009-03-09 07:11:31 |
| Message-ID: | 49B4C123.9060205@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tom Spencer wrote:
> I need to compare the age of some data files against the "age" (i.e.
> time of last commit) of the database. If the data files are newer
> then the database needs to be rebuilt.
>
> I can kludge together a solution but by far the cleanest solution
> would be to just ask "what time was the last commit?"
Only so long as nothing else updates a table. Which would mean not
running autovacuum etc.
Simplest solution would be to have an "import_events" table and just add
a row to that every time you import.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scara Maccai | 2009-03-09 08:14:57 | Matching dimensions in arrays |
| Previous Message | Mark Mandel | 2009-03-09 06:04:19 | Re: Random Deadlock on DROP CONSTRAINT |