From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
---|---|
To: | Hannu Krosing <hannu(at)tm(dot)ee> |
Cc: | <greg(at)turnstep(dot)com>, <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Are we losing momentum? |
Date: | 2003-04-21 15:30:49 |
Message-ID: | Pine.LNX.4.33.0304210927550.5883-100000@css120.ihs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-general pgsql-hackers pgsql-patches |
On 16 Apr 2003, Hannu Krosing wrote:
> greg(at)turnstep(dot)com kirjutas K, 16.04.2003 kell 16:51:
> > The original poster had some
> > valid points (auto-vacuum and non-intuitive commands) that still need
> > addressing, IMO.
>
> As of 7.3 (or was it 7.2) auto-vacuum is just one line in crontab. In
> many scenarios it can be left running continuously with very little
> effect on performance. In others it must be run nightly, but having it
> kick in at unexpected times may not be what you want at all. So it has
> to be configured for good performance weather it is built-in or run in a
> separate backend process.
>
> And I can't see how "show tables" is more intuitive than "\dt" - I
> expected it to be "list tables" or "tablelist" or "näita tabeleid" .
'show tables' is SQL, and can be run from a script, with the output
parsed. For some reason when I run a query of \dt from PHP I get an
error. :-)
> Once you have found \? it is all there (and you are advised to use \? at
> psql startup).
I love \ commands, but remember, those are psql commands, not postgresql
commands. show tables would be a postgreSQL command the backend parser
would understand. Apples and Oranges.
> That may also be why PostgreSQL is more popular in Japan - if one has to
> remember nonsensical strings, then it is easier to remember short ones
But, how do I write an app to ask such questions easily? psql -E is not
the easiest and most intuitive way to learn how to get the data into a
structure for parsing in a client side app.
From | Date | Subject | |
---|---|---|---|
Next Message | Shridhar Daithankar | 2003-04-21 15:44:33 | Re: Are we losing momentum? |
Previous Message | justin | 2003-04-19 08:02:34 | Re: Change to Advocacy Site requested |
From | Date | Subject | |
---|---|---|---|
Next Message | Shridhar Daithankar | 2003-04-21 15:44:33 | Re: Are we losing momentum? |
Previous Message | Chris Gamache | 2003-04-21 15:12:07 | Re: DBI & DBD::Pg processor load |
From | Date | Subject | |
---|---|---|---|
Next Message | Shridhar Daithankar | 2003-04-21 15:44:33 | Re: Are we losing momentum? |
Previous Message | Bruce Momjian | 2003-04-21 14:35:20 | Re: [HACKERS] rename/unlink handling for Win32 |
From | Date | Subject | |
---|---|---|---|
Next Message | Shridhar Daithankar | 2003-04-21 15:44:33 | Re: Are we losing momentum? |
Previous Message | Bruce Momjian | 2003-04-21 14:35:20 | Re: [HACKERS] rename/unlink handling for Win32 |