Re: [HACKERS] src/bin/scripts seems a bit of a misnomer now

2003-06-23 Thread Bruce Momjian

Added to TODO:

* Rename /scripts directory because they are all C programs now


---

Tom Lane wrote:
> Rod Taylor <[EMAIL PROTECTED]> writes:
> > How about just pulling them up a directory into src/bin?
> 
> Nah, I don't like that.  All the programs are at the same level in the
> src/bin tree, and I think it should stay that way.
> 
> Bruce's idea of calling it "tools" seems reasonable ... although there
> might be some confusion because we also have a src/tools directory.
> "admintools" seems a bit long to me, although I'd go along if other
> people like it.  Maybe just "admin"?
> 
>   regards, tom lane
> 

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


Re: [HACKERS] src/bin/scripts seems a bit of a misnomer now

2003-06-20 Thread Robert Treat
On Thu, 2003-06-19 at 12:09, Jon Jensen wrote:
> On Thu, 19 Jun 2003, Christopher Kings-Lynne wrote:
> 
> > Does anyone care about contrib/reindexdb anymore?
> 
> I would've found it handy, but didn't know about it and wrote my own in
> Perl. Inside a transaction it drops the index then rebuilds it using what
> it gets from pg_get_indexdef(), and it looks at the index files on disk
> before and after to show disk space saved (or grown) per index and total.  
> I run it weekly in cron.
> 
> Is something like that of use to anyone else?
> 

I think something like this was either posted to the list, put on gborg,
or maybe hidden in contrib somewhere. I'd like a copy if you don't mind,
I currently use reindex regularly on my database but your script sounds
a little more informational.

Robert Treat 
-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


---(end of broadcast)---
TIP 8: explain analyze is your friend


Re: [HACKERS] src/bin/scripts seems a bit of a misnomer now

2003-06-19 Thread Christopher Kings-Lynne
> "Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> > Does anyone care about contrib/reindexdb anymore?
> 
> I'd think it's still at least as useful as clusterdb.  Why, are you
> thinking of doing some work on it?

No, I just noticed that it escaped the C conversion...

Chris


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [HACKERS] src/bin/scripts seems a bit of a misnomer now

2003-06-19 Thread Jon Jensen
On Thu, 19 Jun 2003, Christopher Kings-Lynne wrote:

> Does anyone care about contrib/reindexdb anymore?

I would've found it handy, but didn't know about it and wrote my own in
Perl. Inside a transaction it drops the index then rebuilds it using what
it gets from pg_get_indexdef(), and it looks at the index files on disk
before and after to show disk space saved (or grown) per index and total.  
I run it weekly in cron.

Is something like that of use to anyone else?

Jon

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


Re: [HACKERS] src/bin/scripts seems a bit of a misnomer now

2003-06-18 Thread Tom Lane
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> Does anyone care about contrib/reindexdb anymore?

I'd think it's still at least as useful as clusterdb.  Why, are you
thinking of doing some work on it?

regards, tom lane

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


Re: [HACKERS] src/bin/scripts seems a bit of a misnomer now

2003-06-18 Thread Christopher Kings-Lynne
> With Peter's latest commit, there aren't any actual scripts left in
> src/bin/scripts; only C programs.  Does that bother anyone?  I was
> wondering about renaming to something like src/bin/misc.  (Not that
> that name seems very compelling either...)

Does anyone care about contrib/reindexdb anymore?

Chris


---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


Re: [HACKERS] src/bin/scripts seems a bit of a misnomer now

2003-06-18 Thread Tom Lane
Rod Taylor <[EMAIL PROTECTED]> writes:
> How about just pulling them up a directory into src/bin?

Nah, I don't like that.  All the programs are at the same level in the
src/bin tree, and I think it should stay that way.

Bruce's idea of calling it "tools" seems reasonable ... although there
might be some confusion because we also have a src/tools directory.
"admintools" seems a bit long to me, although I'd go along if other
people like it.  Maybe just "admin"?

regards, tom lane

---(end of broadcast)---
TIP 8: explain analyze is your friend


Re: [HACKERS] src/bin/scripts seems a bit of a misnomer now

2003-06-18 Thread Rod Taylor
On Wed, 2003-06-18 at 17:07, Bruce Momjian wrote:
> Tom Lane wrote:
> > With Peter's latest commit, there aren't any actual scripts left in
> > src/bin/scripts; only C programs.  Does that bother anyone?  I was
> > wondering about renaming to something like src/bin/misc.  (Not that
> > that name seems very compelling either...)
> 
> We could call it tools or admintools.

How about just pulling them up a directory into src/bin?

If they were complex, each would have a subdirectory in src/bin, so it
seems reasonable to have individual files there.
-- 
Rod Taylor <[EMAIL PROTECTED]>

PGP Key: http://www.rbt.ca/rbtpub.asc


signature.asc
Description: This is a digitally signed message part


Re: [HACKERS] src/bin/scripts seems a bit of a misnomer now

2003-06-18 Thread Bruce Momjian
Tom Lane wrote:
> With Peter's latest commit, there aren't any actual scripts left in
> src/bin/scripts; only C programs.  Does that bother anyone?  I was
> wondering about renaming to something like src/bin/misc.  (Not that
> that name seems very compelling either...)


We could call it tools or admintools.

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]