Slightly off topic confirmations...
And here are are the default settings for OS X 10.2.6:
sysctl -w kern.sysv.shmmax=4194304
Seems to be the default on 10.2.8 as well.
10.1.5 doesn't seem to have a kern.sysv.* section:
[broccoli:~] erics% sysctl kern.sysv.shmmax
second level name sysv in k
Ron Johnson wrote:
On Tue, 2003-10-28 at 07:04, Shridhar Daithankar wrote:
Actually it could be a nice feature if we could access them. For certain
applications, having entire database audited is like dream come true. Of
course it has to provide timestamps/transaction ids as well but in general
>> And here are are the default settings for OS X 10.2.6:
>>
>> sysctl -w kern.sysv.shmmax=4194304
>
>Well, I can only say that if I lower shmmax to that value, initdb picks
>max_connections = 50
>shared_buffers = 300
I just did a fresh install of 7.4b5 on a fresh install of MacOS 10.3, and i
On Wed, Oct 29, 2003 at 01:24:56AM +1100, Brendan Jurd wrote:
> from your question that you are), then the results are reported back via
> the utility "less" (or a less-like program internal to psql, can someone
> else clarify?)
Actually, it's your $PAGER environment variable (and there's the
u
On Tue, Oct 28, 2003 at 09:03:12AM +, Jaime Casanova wrote:
>
> Hi everybody, can anyone tell me if there's a way to retrieve the select
> instruction executed from the catalogs, or maybe via some structure in a
> trigger?
You could turn on query logging and read the Postgres logs.
A
--
BenLaKnet wrote:
I use postgresql 7.2.3
How can I use connectby ??
Must I install files ? or packages ? or it is recommanded to upgrade
dataserver ?
You need to upgrade. Either install 7.3.4 or wait a few weeks and
install 7.4 when it is released.
Joe
---(end of broadc
On Tuesday 28 October 2003 17:13, Alex Page wrote:
> I haven't used PostgreSQL for nearly a year now, and when I was last
> using it there was some discussion on versioning control being
> introduced as a feature. Basically, for some data, I'd like to keep
> track of who changed it, when, and to wh
2003-10-28 kl. 14.33 skrev Jeff:
1. in psql, \pset pager will turn paging off.
Although, if you really want a row count, a much better way to do that
is select count(*) from [rest of select statement]
Thanks.
I'm not new to SQL, just to postgresql, so I know about the
Count-function ;)
Reason
On Tue, 2003-10-28 at 07:04, Shridhar Daithankar wrote:
> On Tuesday 28 October 2003 17:13, Alex Page wrote:
> > I haven't used PostgreSQL for nearly a year now, and when I was last
> > using it there was some discussion on versioning control being
> > introduced as a feature. Basically, for some d
On Tue, Oct 28, 2003 at 12:37:29 +0100,
Christian Wetzig <[EMAIL PROTECTED]> wrote:
>
> i can do the same without any problems, if i connect without ssl or via
> local socket. the problem also occurs with DBI. so, i think it's not a
> psql issue.
>
> i'm using Postgres 7.3.4 on slackware 9.0
hi,
i have a table with test_field of type "TEXT". when i do:
select test_field from test where id=1;
the connection (with psql) hangs and no output is received, so i have to
kill psql.
this occurs, at first sight, if length(test_field)>32748.
i think, in more general, the problem occurs, whe
Are presently converting from mysql to postgresql, and my first
newbiequestion is how to make all the rows in a result from a select
just "swosh" by? That is, I dont want to see them page for page; just
to scroll by so I can se the last line with the number of corresponding
rows.
And is there
On Tuesday 28 October 2003 16:06, Tomas Larsson wrote:
> Hi!
>
> We're trying to call a set-returning stored procedure
> from Excel (MS Query). To do this we type:
>
> select * from getStudents()
>
> (where getStudents() is the stored procedure).
> The problem is that MS Query interprets this as if
I haven't used PostgreSQL for nearly a year now, and when I was last
using it there was some discussion on versioning control being
introduced as a feature. Basically, for some data, I'd like to keep
track of who changed it, when, and to what. I know I could include
multiple values in the schema, a
Thanks Shridhar!
Works like a charm!
/tomas, Patrik and Siv.
--- Shridhar Daithankar
<[EMAIL PROTECTED]> wrote:
> On Tuesday 28 October 2003 16:06, Tomas Larsson
> wrote:
> > Hi!
> >
> > We're trying to call a set-returning stored
> procedure
> > from Excel (MS Query).
> Create a dummy table a
Hi,
This might be useful
www.etooss.com
Ben
Hi!
We're trying to call a set-returning stored procedure
from Excel (MS Query). To do this we type:
select * from getStudents()
(where getStudents() is the stored procedure).
The problem is that MS Query interprets this as if
getStudents was a table, and complains that there is
no table called
Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> Well, some googleing around seems to indicate that Serial ATA I/ATA-6 has
> Tagged Command Queueing (TCQ) which is adding this feature specifically.
> Whether it is a mandatory part of the spec I don't know.
Yeah? If so, and *if fully implement
Hi everybody, can anyone tell me if there's a way to retrieve the select
instruction executed from the catalogs, or maybe via some structure in a
trigger?
The reason is that i have some selects constructed on-the-fly (just part of
it) and i want to save that in a table in order to know what are
On Tue, Oct 28, 2003 at 12:17:59AM -0500, Tom Lane wrote:
> "Rick Gigger" <[EMAIL PROTECTED]> writes:
> > Do serial ATA drives suffer from the same issue?
>
> Um, not an expert, but I think ATA is the same as IDE except for bus
> width and transfer rate. If either one allows for multiple concurre
Rick Gigger wrote:
I have heard that postgres will not use an index unless the field has
a not null constraint on it. Is that true?
I have never heard that. There are some oddities with using an Index.
For example,
if you are using a bigint you need to '' the value or if you are using
an aggre
"Rick Gigger" <[EMAIL PROTECTED]> writes:
>> "we have no portable means of expressing that exact constraint to the
>> kernel"
> Does this mean that specific operating systems have a better way of dealing
> with this? Which ones and how?
I'm not aware of any that offer a way of expressing "write t
I agree with you on using the right tool for the job. Except Perl.
The more I use other languages, the less I want to use Perl. Maybe it was
a bad experience as a junior developer long ago with it or something :-)
The problem with Perl is that it is written to provide any and all ways
to
Thanks! Now it is much, much more clear. It leaves me with a few
additional questions though.
Question 1:
"we have no portable means of expressing that exact constraint to the
kernel"
Does this mean that specific operating systems have a better way of dealing
with this? Which ones and how? I'm
Ron wrote:
...
If you are just running the occasional query and want the results placed
into an Excel spreadsheet, you should look at pgAdmin. You run it from
your windows box and you can run queries and have the results displayed
-> on screen, ->written to a file, ->or to an Excel spreadsheet.
scott.marlowe wrote:
Was there a performance difference in the set with write cache on or off?
Yes - just in the process of a little study concerning this - I will
post some preliminary results soon
cheers
Mark
---(end of broadcast)---
TIP 5
> hi
>
> I have menu table:
> id | integer | not null default
> nextval('public.menu_id_seq'::text)
> parent_id | integer |
> description | text|
>
> I do select:
> test=> SELECT * FROM connectby('menu','id','parent_id','2',0,'~') t(id
> integer, parent_id integer, level in
ahhh. "lies about write order" is the phrase that I was looking for. That
seemed to make sense but I didn't know if I could go directly from "lying
about fsync" to that. Obviously I don't understand exactly what fsync is
doing. I assume this means that if you were to turn fsync off you would get
Tom, this discussion brings up something that's been bugging me about the
recommendations for getting more performance out of PG.. in particular the
one that suggests you put your WAL files on a different physical drive from
the database.
Consider the following scenario:
Database on drive1
WAL
I have heard that postgres will not use an index
unless the field has a not null constraint on it. Is that
true?
Sean Chittenden wrote:
> >
> > If you want to suppress *all* pg_temp_ schemas from the \dn listing,
> > that would be defensible maybe. I'd be inclined to say that
> > pg_toast should be hidden as well if that approach is taken, because
> > then you are basically saying that \dn is not the truth
31 matches
Mail list logo
