Groups > comp.databases.postgresql > #394

Re: scan into many tables

Path	csiph.com!usenet.pasdenom.info!aioe.org!.POSTED!not-for-mail
From	Don Y <this@isnotme.com>
Newsgroups	comp.databases.postgresql
Subject	Re: scan into many tables
Date	Sun, 22 Jul 2012 10:30:21 -0700
Organization	Aioe.org NNTP Server
Lines	31
Message-ID	<juhdbb$lvb$1@speranza.aioe.org> (permalink)
References	<jtphan$934$1@dont-email.me> <zRp-rbau@news.chiark.greenend.org.uk> <jtpr8r$4jv$2@dont-email.me> <87eho4844v.fsf@einstein.gmurray.org.uk> <3zCBTVau@news.chiark.greenend.org.uk>
NNTP-Posting-Host	IUd/GS6iAJlDapkOMz1WFA.user.speranza.aioe.org
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding	7bit
X-Complaints-To	abuse@aioe.org
User-Agent	Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.28) Gecko/20120306 Thunderbird/3.1.20
X-Notice	Filtered by postfilter v. 0.8.2
Xref	csiph.com comp.databases.postgresql:394

Show key headers only | View raw

Hi Mathew,

On 7/22/2012 5:09 AM, Matthew Woodcraft wrote:
> In article<87eho4844v.fsf@einstein.gmurray.org.uk>,
> Graham Murray<newspost@gmurray.org.uk>  wrote:
>> Greg Hennessy<greg.hennessy@cox.net>  writes:
>>
>>> I don't see a parameter with this name in my postgresql.conf file.
>>> I'm running 8.1.23, on Redhat 5.
>>
>> You should seriously consider upgrading as postgresql 8.1 went EOL in
>> November 2010.
>
> 8.1 is what shipped with RHEL 5, so I think Red Hat will be providing
> full support for some time yet.
>
> (Of course there are other good reasons to upgrade, but I imagine if it
> was easy to do he'd have done it already.)

"Easy" doesn't mean that it doesn't "take time".  As with most
projects, *that* is usually the limiting factor (only so many
hours in a day!)

I've found it is reasonably painless to move (forward) along the
pg upgrade path.  It's a bit of a chore dumping and reloading
an entire database (depending on size and secondary storage you have
available to you) but (so far), so far, the process seems to go without
a hitch.

OTOH, I always build from sources so if you're stuck waiting for
a prepackaged binary, your mileage *will* vary  :-/

Thread

scan into many tables Greg Hennessy <greg.hennessy@cox.net> - 2012-07-13 16:11 +0000
  Re: scan into many tables Hans Castorp <REWYRLXHEGHO@spammotel.com> - 2012-07-13 18:37 +0200
    Re: scan into many tables Greg Hennessy <greg.hennessy@cox.net> - 2012-07-13 18:54 +0000
    Re: scan into many tables Greg Hennessy <greg.hennessy@cox.net> - 2012-07-13 20:48 +0000
  Re: scan into many tables Matthew Woodcraft <mattheww@chiark.greenend.org.uk> - 2012-07-13 17:51 +0100
    Re: scan into many tables Greg Hennessy <greg.hennessy@cox.net> - 2012-07-13 19:00 +0000
      Re: scan into many tables Matthew Woodcraft <mattheww@chiark.greenend.org.uk> - 2012-07-13 22:15 +0100
      Re: scan into many tables Graham Murray <newspost@gmurray.org.uk> - 2012-07-22 11:46 +0100
        Re: scan into many tables Matthew Woodcraft <mattheww@chiark.greenend.org.uk> - 2012-07-22 13:09 +0100
          Re: scan into many tables Robert Klemme <shortcutter@googlemail.com> - 2012-07-22 18:55 +0200
            Re: scan into many tables Matthew Woodcraft <mattheww@chiark.greenend.org.uk> - 2012-07-22 21:07 +0100
          Re: scan into many tables Don Y <this@isnotme.com> - 2012-07-22 10:30 -0700
            Re: scan into many tables Hans Castorp <REWYRLXHEGHO@spammotel.com> - 2012-07-22 20:24 +0200
              Re: scan into many tables Don Y <this@isnotme.com> - 2012-07-22 12:54 -0700
        Re: scan into many tables Greg Hennessy <greg.hennessy@cox.net> - 2012-07-22 22:57 +0000
  Re: scan into many tables Jasen Betts <jasen@xnet.co.nz> - 2012-07-14 02:55 +0000

csiph-web