On 6 Jan 2003 at 6:48, Greg Copeland wrote:
1) Get I/O time used fuitfully
AIO may address this without the need for integrated threading.
Arguably, from the long thread that last appeared on the topic of AIO,
some hold that AIO doesn't even offer anything beyond the current
implementation.
Hi guys,
Also received a through the Advocacy website asking if anyone has
ported PostgreSQL to the AlphaServers under VMS.
Anyone know if we run on VMS? Last time I touched VMS (about 10 years
ago) it wasn't all that Unix-like.
:-)
Regards and best wishes,
Justin Clift
--
My grandfather
Hi guys,
Have passed on the info everyone provided about ways of getting
PostgreSQL working on the OS/400 on to the requestor. It would be
interesting to see if they go with it.
Thanks for the assistance... more stuff will keep on coming through of
course.
:-)
Regards and best wishes,
-Original Message-
From: Kristis Makris [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2003 03:05
To: Francisco Figueiredo Jr.
Cc: [EMAIL PROTECTED]
Subject: Re: [Npgsql-general] Get function OID and function
calling support
Hi Francicso,
I could, however, call a function
-Original Message-
From: Lamar Owen [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2003 06:12
To: Christopher Kings-Lynne; Hackers; [EMAIL PROTECTED]
Subject: Re: [HACKERS] Thank-you to Cybertec Geschwinde Schonig
On Monday 06 January 2003 21:01, Christopher Kings-Lynne wrote:
On Fri, 03 Jan 2003 15:37:56 -0500, Tom Lane [EMAIL PROTECTED] wrote:
The system tables are not the problem. [...]
Changes in the on-disk representation of user tables would be harder to
deal with, but they are also much rarer (AFAIR we've only done that
twice: WAL required additions to page and
On Tue, 07 Jan 2003 11:18:15 +0100, I wrote:
what I have hacked together yesterday afternoon:
[included it twice]
Sorry!
Servus
Manfred
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail
Tom Lane writes:
Bruce Momjian [EMAIL PROTECTED] writes:
We have definatly had requests for improved thread-safeness for libpq
and ecpg in the past, so whatever you can do would be a help. We say
libpq is thread-safe, but specifically mention the non-threadsafe calls
in the libpq
On Tue, 7 Jan 2003, Justin Clift wrote:
Hi everyone,
Just found out that the pgdiff utility (the one for comparing two
different PostgreSQL database's) was released and uploaded to
SourceForge in November:
http://sourceforge.net/projects/pgdiff
Have people already looked at this?
I
Dear all,
Does psql support UTF-8 encoding?
su postgres
psql template1
CREATE DATABASE foo_é WITH encoding = 'Unicode';
does not work.
It seems that Schema objects only accept ASCII letters.
Do I miss something?
Cheers,
Jean-Michel POURE
---(end of
I have a problem...
We're using cursors to be able to fetch X tuples from the server.
If we would take 'em all our app would blow up because of memory
constraints.
What i would like to is something like this:
mag=# create table test (id serial unique primary key, txt text);
mag=# insert into
Dear all,
We are working on PhpPgAdmin UTF-8 support. I would like to be able to view
UTF-8, ASCII and Latin1 databases in PhpPgAdmin without changing HTML header
encodings.
I guess this can be done using:
SET CLIENT_ENCODING='Unicode'
for all PhpPgAdmin connections.
My question are:
- Are
On Tue, Jan 07, 2003 at 02:29:30PM +0100, Magnus Naeslund(f) wrote:
mag=# create table test (id serial unique primary key, txt text);
mag=# insert into test(txt) values('hoho1');
mag=# prepare berra (integer) as select * from test where id = $1;
mag=# declare berra_c cursor for execute
Justin Clift [EMAIL PROTECTED] writes:
Anyone know if we run on VMS?
I'm pretty sure we don't. But there are plenty of Linux and *BSD
distros that will run on that hardware.
regards, tom lane
---(end of broadcast)---
TIP
IIRC, they too have a POSIX layer available.
Greg
On Tue, 2003-01-07 at 02:44, Justin Clift wrote:
Hi guys,
Also received a through the Advocacy website asking if anyone has
ported PostgreSQL to the AlphaServers under VMS.
Anyone know if we run on VMS? Last time I touched VMS (about
I forgot to reply to the list aswell...
Magnus
- Original Message -
From: Magnus Naeslund(f) [EMAIL PROTECTED]
To: Jeroen T. Vermeulen [EMAIL PROTECTED]
Sent: Tuesday, January 07, 2003 3:32 PM
Subject: Re: [HACKERS] Error using cursors/fetch and execute
Jeroen T. Vermeulen [EMAIL
On Tue, 2003-01-07 at 02:00, Shridhar Daithankar wrote:
On 6 Jan 2003 at 6:48, Greg Copeland wrote:
1) Get I/O time used fuitfully
AIO may address this without the need for integrated threading.
Arguably, from the long thread that last appeared on the topic of AIO,
some hold that AIO
Forwarded from a response on pgsql-sql:
I thought that the idea behind noup was to protect single columns from
update. However, when I apply the noup trigger as above, I can't
update /any/ column. Is this the intended behaviour?
Idly looking at the source code for contrib/noupdate/noup.c, I
Dave Page [EMAIL PROTECTED] writes:
Sorry, don't know. Can anyone on pgsql-hackers tell us the purpose of
the FunctionCall message?
It's used to invoke the fast path function call code
(src/backend/tcop/fastpath.c). libpq's large-object routines use this,
but little else does AFAIK. The
Justin Clift wrote:
Hi guys,
Also received a through the Advocacy website asking if anyone has
ported PostgreSQL to the AlphaServers under VMS.
Anyone know if we run on VMS? Last time I touched VMS (about 10 years
ago) it wasn't all that Unix-like.
It used to work under VMS a few
Greg Copeland [EMAIL PROTECTED] writes:
That's the power of using the process model that is currently in use. Should
it do something naughty, we bitch and complain politely, throw our hands in
the air and exit. We no longer have to worry about the state and validity of
that backend.
You
On Tue, 2003-01-07 at 12:21, Greg Stark wrote:
Greg Copeland [EMAIL PROTECTED] writes:
That's the power of using the process model that is currently in use. Should
it do something naughty, we bitch and complain politely, throw our hands in
the air and exit. We no longer have to worry
Greg Stark [EMAIL PROTECTED] writes:
You missed the point of his post. If one process in your database does
something nasty you damn well should worry about the state of and validity of
the entire database, not just that one backend.
Right. And in fact we do blow away all the processes when
Bruce Momjian writes:
Lee Kindness wrote:
Right, so a reasonable angle for me to take is to go through the libpq
source looking for potential problem areas and use of known bad
functions. I can add autoconf checks for the replacement *_r()
functions, and use these in place of the
San someone point me to what exactly is planned for the
protocol/networking stuff? Networking/protocols is one of my fortes and
I believe that I could actually help here.
Regards,
Greg
On Tue, 2003-01-07 at 09:01, Tom Lane wrote:
Dave Page [EMAIL PROTECTED] writes:
Sorry, don't
You mean ship with only IPv4 enabled, but not IPv6. (Of course, both
are enabled in the binary.) But then what does -i do? We currently
tell people to use -i. Do we need another postgresql.conf option that
says, If tcpip_socket is enabled, enable IPv6 too? But that doesn't
work if you want
Another idea is to have the -i take an optional argument. Something where
-i means bind to both v4 and v6, and -i4 means to only v4, and -i6 to only
v6.
I am guessing that most people will want to bind to both when they
just specify -i, which is what is usually suggested when they want to get
Rocco Altier [EMAIL PROTECTED] writes:
Another idea is to have the -i take an optional argument. Something where
-i means bind to both v4 and v6, and -i4 means to only v4, and -i6 to only
v6.
I don't see why we need any such thing. The current behavior of the
postmaster (assuming -i or
--On Tuesday, January 07, 2003 11:51:44 -0500 Tom Lane [EMAIL PROTECTED]
wrote:
Rocco Altier [EMAIL PROTECTED] writes:
Another idea is to have the -i take an optional argument. Something
where -i means bind to both v4 and v6, and -i4 means to only v4, and -i6
to only v6.
I don't see why we
Larry Rosenman [EMAIL PROTECTED] writes:
Please make sure that you can handle the situation of a IPv6 API, but no
IPv6 stack. (E.G. UnixWare up to at least 7.1.3).
Certainly. But that is just an autoconfiguration problem. If a v6 IP
address is available, we should bind to it.
Tom Lane wrote:
Rocco Altier [EMAIL PROTECTED] writes:
Another idea is to have the -i take an optional argument. Something where
-i means bind to both v4 and v6, and -i4 means to only v4, and -i6 to only
v6.
I don't see why we need any such thing. The current behavior of the
Larry Rosenman wrote:
No one has offered any scenario in which it's important to bind to only
v4 or only v6 addresses when both are present. In the absence of a
compelling argument why that would be useful, I do not see why we're
worrying. My own thought is that if I wanted to constrain
--On Tuesday, January 07, 2003 12:07:05 -0500 Tom Lane [EMAIL PROTECTED]
wrote:
Larry Rosenman [EMAIL PROTECTED] writes:
Please make sure that you can handle the situation of a IPv6 API, but no
IPv6 stack. (E.G. UnixWare up to at least 7.1.3).
Certainly. But that is just an
Tom Lane wrote:
Larry Rosenman [EMAIL PROTECTED] writes:
Please make sure that you can handle the situation of a IPv6 API, but no
IPv6 stack. (E.G. UnixWare up to at least 7.1.3).
Certainly. But that is just an autoconfiguration problem. If a v6 IP
address is available, we should bind
Bruce Momjian [EMAIL PROTECTED] writes:
We already do. The issue is what way should we give admins to _fail_ if
IPv6 doesn't start.
What is IPv6 doesn't start? Either the machine has IPv6 addresses,
or it doesn't. It is not our job to notify the DBA what the addresses
on his machine are.
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
The issue was that folks didn't like silent fallback to just IPv4 if the
code supported IPv6 but it didn't bind to IPv6 for some reason, e.g.
kernel doesn't have IPv6 enabled.
Who didn't like it, and what was their rationale? This
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
We already do. The issue is what way should we give admins to _fail_ if
IPv6 doesn't start.
What is IPv6 doesn't start? Either the machine has IPv6 addresses,
or it doesn't. It is not our job to notify the DBA what the addresses
Joe Conway writes:
I found the definition in FIPS 127-2:
http://www.itl.nist.gov/fipspubs/fip127-2.htm
The relevant section is section 16.6.
The table described there does not match the schema of the SQL_SIZING
table defined in the SQL standard. I'm also suspicious because the
--- Tom Lane [EMAIL PROTECTED] escreveu:
Dave Page [EMAIL PROTECTED] writes:
Sorry, don't know. Can anyone on pgsql-hackers tell us the purpose of
the FunctionCall message?
It's used to invoke the fast path function call code
(src/backend/tcop/fastpath.c). libpq's large-object routines
Hi all,
How is this path created without the (.profile)?
$ echo $PATH
/usr/local/bin:/usr/bin:/bin:/cygdrive/c/amtagent:/cygdrive/c/informix/bin:/cygd
rive/c/winnt:/cygdrive/c/winnt/system:winnt/system32:/cygdrive/c/Windows:/cygdri
ve/c/Windows/command:C:jdk1.2.2/bin
How can I add this path
On 7 Jan 2003 at 16:25, mlw wrote:
I think banner ads that build on PostgreSQL's message is a good thing.
A RedHat ad, maybe IBM, etc. Companies with a related purpose to the
PostgreSQL mission will offset some of the cost and help build the
cedibility of the site.
Hotel ads and
On Tue, 7 Jan 2003, Dan Langille wrote:
On 7 Jan 2003 at 16:25, mlw wrote:
I think banner ads that build on PostgreSQL's message is a good thing.
A RedHat ad, maybe IBM, etc. Companies with a related purpose to the
PostgreSQL mission will offset some of the cost and help build the
Larry Rosenman wrote:
--On Tuesday, January 07, 2003 12:20:31 -0500 Tom Lane [EMAIL PROTECTED]
wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
We already do. The issue is what way should we give admins to _fail_ if
IPv6 doesn't start.
What is IPv6 doesn't start? Either the
--On Tuesday, January 07, 2003 12:24:41 -0500 Bruce Momjian
[EMAIL PROTECTED] wrote:
Larry Rosenman wrote:
--On Tuesday, January 07, 2003 12:20:31 -0500 Tom Lane
[EMAIL PROTECTED] wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
We already do. The issue is what way should we give admins
Justin Clift writes:
Just found out that the pgdiff utility (the one for comparing two
different PostgreSQL database's) was released and uploaded to
SourceForge in November:
A diff utility with a mandatory GUI frontend through a webserver is
positively the most bizarre thing I have ever heard
On Tuesday 07 January 2003 12:40, Peter Eisentraut wrote:
Justin Clift writes:
Just found out that the pgdiff utility (the one for comparing two
different PostgreSQL database's) was released and uploaded to
SourceForge in November:
A diff utility with a mandatory GUI frontend through a
*raised eyebrow* Someone want to scan and post one of these?
On Tue, 7 Jan 2003, Dave Page wrote:
-Original Message-
From: Lamar Owen [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2003 06:12
To: Christopher Kings-Lynne; Hackers; [EMAIL PROTECTED]
Subject: Re: [HACKERS]
Tom Lane writes:
Where are you planning to check this?
In general, I'm trying to align it like a (self-imposed) permission check.
For the query-like statements I'm looking at ExecCheckRTPerms(). (That
also handles EXECUTE and EXPLAIN most easily.) Utility statements have a
check in
This is a serious inquiry, very serious. People are complaining about ads.
What do we need in the form of equipment, bandwidth, etc.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Tue, 7 Jan 2003, mlw wrote:
This is a serious inquiry, very serious. People are complaining about ads.
What do we need in the form of equipment, bandwidth, etc.
FTP is just over 800MB, plan for growth.
WEB is just over 90MB, can't tell you what to plan for there.
On www/ftp.us I don't
On 7 Jan 2003, Greg Copeland wrote:
On Tue, 2003-01-07 at 16:46, Vince Vielhaber wrote:
On Tue, 7 Jan 2003, mlw wrote:
This is a serious inquiry, very serious. People are complaining about ads.
What do we need in the form of equipment, bandwidth, etc.
FTP is just over 800MB,
On Tue, Jan 07, 2003 at 03:10:06PM -0800, Dann Corbit wrote:
NOTICE: QUERY PLAN:
SetOp Except (cost=202028537.97..202120623.90 rows=1227812 width=24)
- Sort (cost=202028537.97..202028537.97 rows=12278124 width=24)
- Append (cost=1.00..200225099.24 rows=12278124
-Original Message-
From: johnn [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 3:33 PM
To: [EMAIL PROTECTED]
Subject: Re: [GENERAL] [HACKERS] I feel the need for speed.
What am I doing wrong?
On Tue, Jan 07, 2003 at 03:10:06PM -0800, Dann Corbit wrote:
NOTICE:
Dann Corbit [EMAIL PROTECTED] writes:
No analyze for 7.1.3.
Just ran vacuum a few minutes before the query. No boost at all.
VACUUM or VACUUM ANALYZE? Standalone ANALYZE was not in 7.1 but
VACUUM ANALYZE does what you need to do...
-Doug
---(end of
Bruce Momjian writes:
Peter was the first to mention it. His reasoning was that if IPv6 was
working, but then stopped working, the admin would never know on startup
because of the IPv4 fallback.
My view was that we should treat unix, ipv4, and ipv6 as independent
address families each with
Jean-Michel POURE writes:
- Are some database encodings not translatable into UTF-8 using SET
CLIENT_ENCODING = 'Unicode'. It used to be the case for Latin1, but it has
been fixed now.
It should be possible. If not, it's a bug.
- Some letters, like the euro sign, do not belong to Latin1.
Hi guys,
My postgres totally messed up again for some reason (there were like 3
postmasters running, other weirdness).
I noticed this as it was starting up again:
2003-01-07 18:01:34 DEBUG: ReadRecord: unexpected pageaddr 16/F2794000 in
log file 22, segment 249, offset 7946240
2003-01-07
Peter Eisentraut [EMAIL PROTECTED] writes:
Tom Lane writes:
Where are you planning to check this?
In general, I'm trying to align it like a (self-imposed) permission check.
For the query-like statements I'm looking at ExecCheckRTPerms(). (That
also handles EXECUTE and EXPLAIN most easily.)
Peter Eisentraut wrote:
Bruce Momjian writes:
Peter was the first to mention it. His reasoning was that if IPv6 was
working, but then stopped working, the admin would never know on startup
because of the IPv4 fallback.
My view was that we should treat unix, ipv4, and ipv6 as
Tom Lane wrote:
"Marc G. Fournier" [EMAIL PROTECTED] writes:
Please understand something here ... a large portion of the banner ads are
*not* paid ... they are recognition of the many mirror sites that are
supporting the project by reducing the amount of bandwidth that is
Yeah, it's called cygwin. Oh, you probably meant that miserable excuse
for a posix layer MS included when they shipped it. :-)
On Tue, 7 Jan 2003, Dave Page wrote:
So does NT iirc ;-)
-Original Message-
From: Greg Copeland [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2003
Sorry to be commenting so late.
We could do that CLUSTER way of making a new heap file, but we rejected
that for DROP COLUMN, so I am not sure why we would use that for ALTER
COLUMN. Can anyone think of a good reason?
Clearly if the new data type is binary compatible and it is just a
catalog
johnn [EMAIL PROTECTED] writes:
On Tue, Jan 07, 2003 at 03:10:06PM -0800, Dann Corbit wrote:
- Seq Scan on CNX_DS_53_SIS_STU_OPT_FEE_TB a
(cost=1.00..100112549.62 rows=6139062 width=24)
Those big round numbers suggest that you haven't run vacuum analyze on
all of your tables.
Yeah, the MS one - sorry 'bout that :-). I was feeling quite chipper
before another day of voip hell...
-Original Message-
From: scott.marlowe [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2003 21:28
To: Dave Page
Cc: Greg Copeland; Justin Clift; PostgresSQL Hackers Mailing List
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
My postgres totally messed up again for some reason (there were like 3
postmasters running, other weirdness).
I noticed this as it was starting up again:
2003-01-07 18:01:34 DEBUG: ReadRecord: unexpected pageaddr 16/F2794000 in
log file 22,
It also logged that it was killed with signal 9, although I
didn't kill it!
Is there something weird going on here?
Is this Linux? The Linux kernel seems to think that killing
randomly-chosen processes with SIGKILL is an appropriate response to
running out of memory. I cannot offhand
I noticed sync() is used in PostgreSQL.
CHECKPOINT - FlushBufferPool() - smgrsync() - mdsync() - sync()
Can someone tell me why we need sync() here?
--
Tatsuo Ishii
---(end of broadcast)---
TIP 2: you can get off all lists at once with the
Dear Peter,
Thank you very much for your answers. It rings a bell.
Finally, when you display East Asian characters you will
have a font problem because the Chinese, Japanese, and Korean characters
are mapped to the same range in Unicode but you are supposed to use
country-specific glyphs.
Dann Corbit wrote:
Message
I have
a machine with 4 CPU's and 2 gigabytes of physical ram.
I would
like to get PostgreSQL to use as much memory as possible. I can't seem
to get PostgreSQL to use more than 100 megabytes or so.
How can
I optimize the use
-Original Message-
From: Vince Vielhaber [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2003 22:47
To: mlw
Cc: [EMAIL PROTECTED]; Marc G. Fournier
Subject: Re: [HACKERS] PostgreSQL site, put up or shut up?
On Tue, 7 Jan 2003, mlw wrote:
This is a serious inquiry, very
Hi,
Is there any way of making the 'up' arrow retrieve all of the last multiline
query, instead of just the last line? It's really annoying working with
large multiline queries at the moment...
Chris
---(end of broadcast)---
TIP 2: you can get
2002-11-12 19:44 momjian
* doc/src/sgml/ref/move.sgml, src/backend/commands/portalcmds.c,
src/backend/executor/execMain.c, src/backend/parser/gram.y,
src/backend/parser/keywords.c, src/backend/tcop/utility.c,
src/include/commands/portalcmds.h,
-Original Message-
From: Jean-Luc Lachance [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 2:43 PM
To: Tom Lane
Cc: Dann Corbit; Nigel J. Andrews;
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [GENERAL] [HACKERS] I feel the need for speed.
What am I doing wrong?
--On Tuesday, January 07, 2003 15:25:06 -0800 Dann Corbit
[EMAIL PROTECTED] wrote:
No analyze for 7.1.3.
Just ran vacuum a few minutes before the query. No boost at all. Even
with SET enable_seqscan = 0 it still does a table scan.
did you do VACUUM ANALYZE?
If not, the stats weren't
Tom Lane wrote:
2002-11-12 19:44 momjian
* doc/src/sgml/ref/move.sgml, src/backend/commands/portalcmds.c,
src/backend/executor/execMain.c, src/backend/parser/gram.y,
src/backend/parser/keywords.c, src/backend/tcop/utility.c,
src/include/commands/portalcmds.h,
Bruce Momjian [EMAIL PROTECTED] writes:
Tom Lane wrote:
Refresh my memory: what is the point of inventing an additional LAST
keyword, when the behavior is exactly the same as MOVE ALL ?
SQL compatibility, per Peter.
Oh, I see. But then really it should be documented as a FETCH keyword,
not
Tom Lane wrote:
(B
(B Bruce Momjian [EMAIL PROTECTED] writes:
(B Tom Lane wrote:
(B Refresh my memory: what is the point of inventing an additional LAST
(B keyword, when the behavior is exactly the same as MOVE ALL ?
(B
(B SQL compatibility, per Peter.
(B
(B Oh, I see. But then
Hiroshi Inoue [EMAIL PROTECTED] writes:
IIRC *FETCH LAST* doesn't mean *FETCH ALL*.
SQL92 says
ii) If the fetch orientation implicitly or explicitly spec-
ifies NEXT, specifies ABSOLUTE or RELATIVE with K greater
than N, or specifies LAST, then CR
Tom Lane wrote:
(B
(B Sure. FETCH n in Postgres has always corresponded to FETCH RELATIVE n.
(B
(BIIRC in SQL standard FETCH retrieves rows one by one.
(B
(Bregards,
(BHiroshi Inoue
(Bhttp://w2422.nsk.ne.jp/~inoue/
(B
(B---(end of
Hiroshi Inoue [EMAIL PROTECTED] writes:
Tom Lane wrote:
Sure. FETCH n in Postgres has always corresponded to FETCH RELATIVE n.
IIRC in SQL standard FETCH retrieves rows one by one.
Yes, Postgres' idea of FETCH is only weakly related to the spec's idea.
But I believe you get similar results
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Tom Lane wrote:
Refresh my memory: what is the point of inventing an additional LAST
keyword, when the behavior is exactly the same as MOVE ALL ?
SQL compatibility, per Peter.
Oh, I see. But then really it should be documented
Tom Lane wrote:
(B
(B Hiroshi Inoue [EMAIL PROTECTED] writes:
(B Tom Lane wrote:
(B Sure. FETCH n in Postgres has always corresponded to FETCH RELATIVE n.
(B
(B IIRC in SQL standard FETCH retrieves rows one by one.
(B
(B Yes, Postgres' idea of FETCH is only weakly related to the
Hiroshi Inoue [EMAIL PROTECTED] writes:
FETCH LAST should return the last one row.
That's not clear to me. Generally, I would think the cursor should
remain positioned on whatever row is returned, but the spec clearly says
that the final cursor position after FETCH LAST is *after* the last row.
Tatsuo Ishii wrote:
I noticed sync() is used in PostgreSQL.
CHECKPOINT - FlushBufferPool() - smgrsync() - mdsync() - sync()
Can someone tell me why we need sync() here?
As part of checkpoint, we discard some WAL files. To do that, we must
first be sure that all the dirty buffers we have
Bruce Momjian [EMAIL PROTECTED] writes:
Tatsuo Ishii wrote:
Can someone tell me why we need sync() here?
As part of checkpoint, we discard some WAL files. To do that, we must
first be sure that all the dirty buffers we have written to the kernel
are actually on the disk. That is why the
Tatsuo Ishii wrote:
I noticed sync() is used in PostgreSQL.
CHECKPOINT - FlushBufferPool() - smgrsync() - mdsync() - sync()
Can someone tell me why we need sync() here?
As part of checkpoint, we discard some WAL files. To do that, we must
first be sure that all the dirty buffers
As part of checkpoint, we discard some WAL files. To do that, we must
first be sure that all the dirty buffers we have written to the kernel
are actually on the disk. That is why the sync() is required.
What we really need is something better than sync(), viz flush all dirty
buffers to
Tatsuo Ishii [EMAIL PROTECTED] writes:
Can someone tell me why we need sync() here?
?? I thought WAL files are synced by pg_fsync() (if needed).
They are. But to write a checkpoint record --- which implies that the
WAL records before it need no longer be replayed --- we have to ensure
that
Tatsuo Ishii [EMAIL PROTECTED] writes:
What we really need is something better than sync(), viz flush all dirty
buffers to disk *and* wait till they're written. But sync() and sleep
for awhile is the closest portable approximation.
Are you saying that fsync() might not wait untill the IO
Are you saying that fsync() might not wait untill the IO completes?
No, I said that sync() might not. Read the man pages. HPUX's man
page for sync(2) says
sync() causes all information in memory that should be on disk to be
written out.
...
The writing, although
Tatsuo Ishii [EMAIL PROTECTED] writes:
I'm just wondering why we do not use fsync() to flush data/index
pages.
There isn't any efficient way to do that AFAICS. The process that wants
to do the checkpoint hasn't got any way to know just which files need to
be sync'd. Even if it did know, it's
Tatsuo Ishii [EMAIL PROTECTED] writes:
I'm just wondering why we do not use fsync() to flush data/index
pages.
There isn't any efficient way to do that AFAICS. The process that wants
to do the checkpoint hasn't got any way to know just which files need to
be sync'd. Even if it did
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2003 15:01
To: Dave Page
Cc: Kristis Makris; Francisco Figueiredo Jr.;
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [HACKERS] [Npgsql-general] Get function OID and
function calling support
So does NT iirc ;-)
-Original Message-
From: Greg Copeland [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2003 15:00
To: Justin Clift
Cc: PostgresSQL Hackers Mailing List
Subject: Re: [HACKERS] Next platform query: Alphaservers under VMS?
IIRC, they too have a POSIX layer
Lee Kindness wrote:
Tom Lane writes:
Bruce Momjian [EMAIL PROTECTED] writes:
We have definatly had requests for improved thread-safeness for libpq
and ecpg in the past, so whatever you can do would be a help. We say
libpq is thread-safe, but specifically mention the non-threadsafe
Yep, got it. Thanks.
---
Christopher Kings-Lynne wrote:
gmake[2]: Entering directory `/home/chriskl/pgsql-head/src/backend'
Makefile:145: *** missing separator (did you mean TAB instead of 8 spaces?).
Stop.
Chris
96 matches
Mail list logo