Seriously, I have wondered if it might be a good idea to assemble a
small hit team that would take some high profile open source projects
and make sure they worked with Postgres. Bugzilla would be the most
obvious candidate, but there are certainly others. I suspect that could
be quite
On Sun, Nov 09, 2003 at 04:12:50PM +0800, Christopher Kings-Lynne wrote:
Seriously, I have wondered if it might be a good idea to assemble a
small hit team that would take some high profile open source projects
and make sure they worked with Postgres. Bugzilla would be the most
obvious
The only idea I have is to call oidin() to do the conversion from string
to oid. I see this in copy.c:
loaded_oid = DatumGetObjectId(DirectFunctionCall1(oidin,
CStringGetDatum(string)));
if (loaded_oid ==
Christopher Kings-Lynne wrote:
The only idea I have is to call oidin() to do the conversion from string
to oid. I see this in copy.c:
loaded_oid = DatumGetObjectId(DirectFunctionCall1(oidin,
CStringGetDatum(string)));
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
| COMMENT ON LARGE OBJECT NumericOnly IS comment_text
n-objname = makeList1(makeAConst($5));
Forget the makeAConst step --- it's just wasted cycles. In the
execution routine, you can use code comparable to define.c's defGetInt64()
to convert
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
I've been using libpqxx to access a Postgres database for the last few
months, and I wrote a set of classes to wrap around libpqxx, which
gradually evolved into a small set of classes and class templates.
These allow database tables and rows
Hi all,
well, the most of the programming itself is done, what's currently missing is
1) Some fine tuning on the layout
2) Adding the static pages
3) Translating the pages, news, events etc. into german and maybe some other languages
if we find someone to translate it
4) Creating something that
I am running PostgreSQL 7.3.1 on i686-pc-linux-gnu, compiled by GCC 2.96
the following query fails:
SELECT 'UPDATE pa_sales_lead SET details = COALESCE(details, \'\') ||
\'' || replace(data, '\'', '\'\'') || '\' WHERE foreign_sales_lead_id =
\'' || id || '\';' FROM temp_sales_lead ORDER BY id,
I think it is part of the incentive for corporations to contribute - not
just an impressive list for PHB. It's nice to get the recognition for
their time/money contributions and a good way for the PGDG to show their
appreciation.
-r
On Thu, 2003-11-06 at 14:34, Josh Berkus wrote:
Peter,
I
On Thu, Nov 06, 2003 at 12:08:56AM +0100, Reinhard Max wrote:
On Wed, 5 Nov 2003 at 13:28, Tom Lane wrote:
Peter Eisentraut [EMAIL PROTECTED] writes:
The SuSE PPC guru said that the PPC spinlock code we currently use
may behave erroneously on multiprocessor systems.
What's his
I'm interested in changing the client encoding from within a java
program. I'm using connection pooling and need to change it depending
on the client's language preference. Is there a function I can call
which changes the client encoding. Something like
pStmt = con.prepareStatement(select
On Thu, 2003-11-06 at 10:35, Tom Lane wrote:
Rod Taylor [EMAIL PROTECTED] writes:
- Hash Join (cost=3D1230.79..60581.82 rows=3D158 width=3D54)=
(actual time=3D1262.35..151200.29 rows=3D1121988 loops=3D1)
Hash Cond: (outer.account_id =3D inner.account_id)
- Hash Join
Manfred Spraul [EMAIL PROTECTED] writes:
Greg Stark wrote:
I'm assuming fsync syncs writes issued by other processes on the same file,
which isn't necessarily true though.
It was already pointed out that we can't rely on that assumption.
So the NetBSD and Sun developers I checked
emeritus is a perfectly good latin word. No need to
dumb things down.
--elein
On Wed, Nov 05, 2003 at 05:26:29PM -0500, Bruce Momjian wrote:
Tom Lane wrote:
Josh Berkus [EMAIL PROTECTED] writes:
B) What contributors are listed under Major Developers who haven't
contributed any code
Yes, I would like to see the vacuum delay patch go into 7.4.1 if possible.
It's really useful. I don't think there is any major risk in adding the
delay patch into a minor revision given the small amount of code change.
Stephen
Matthew T. O'Connor [EMAIL PROTECTED] wrote in message
news:[EMAIL
In article [EMAIL PROTECTED], Lauri Pietarinen
[EMAIL PROTECTED] writes
Anthony W. Youngman wrote:
In article [EMAIL PROTECTED], Lauri Pietarinen lauri.pie
[EMAIL PROTECTED] writes
Anthony W. Youngman wrote:
In article [EMAIL PROTECTED], Lauri Pietarinen
[EMAIL PROTECTED] writes
Well, if it is
On Wed, 5 Nov 2003 at 13:28, Tom Lane wrote:
Peter Eisentraut [EMAIL PROTECTED] writes:
The SuSE PPC guru said that the PPC spinlock code we currently use
may behave erroneously on multiprocessor systems.
What's his evidence for that claim?
Let's ask himself.
The code we have is based
Greg Stark [EMAIL PROTECTED] writes:
Tom Lane [EMAIL PROTECTED] writes:
You want to find, open, and fsync() every file in the database cluster
for every checkpoint? Sounds like a non-starter to me.
Except a) this is outside any critical path, and b) only done every few
minutes and c) the
Clearly I can't spell.
Regards,
David
--- postgresql-7.4RC1/contrib/start-scripts/PostgreSQL.darwin Mon Dec
9 13:26:07 2002
+++ /Users/david/Desktop/PostgreSQL.darwin Wed Nov 5 17:53:23 2003
@@ -18,9 +18,9 @@
#
# POSTGRESQLSERVER=-YES-
#
-# The startup bundle will now be read to
I am trying to find information regarding creation of B-tree index in postgres
for variable length character data (Char/varchar type). Specifically, what
pagination policy is used, does it use prefix BTree, or any other form of
compression (encoding)?
Regards,
VJ Anand
TL == Tom Lane [EMAIL PROTECTED] writes:
TL writes: upper/lower aren't
TL going to work desirably in any multi-byte character set
TL encoding.
Can you please point me at their implementation? I do not
understand why that's impossible.
TL Because they use ctype.h's
Greg Stark wrote:
I'm assuming fsync syncs writes issued by other processes on the same file,
which isn't necessarily true though.
It was already pointed out that we can't rely on that assumption.
So the NetBSD and Sun developers I checked with both asserted fsync does in
fact
The delay patch worked so well, I couldn't resist asking if a similar patch
could be added for COPY command (pg_dump). It's just an extension of the
same idea. On a large DB, backups can take very long while consuming a lot
of IO slowing down other select and write operations. We operate on a
Tom Lane wrote:
Jan Wieck [EMAIL PROTECTED] writes:
How I can see the background writer operating is that he's keeping the
buffers in the order of the LRU chain(s) clean, because those are the
buffers that most likely get replaced soon. In my experimental ARC code
it would traverse the T1 and
TL == Tom Lane [EMAIL PROTECTED] writes:
TL Alexey Mahotkin [EMAIL PROTECTED] writes:
I'm running Postgresql 7.3.4 with ru_RU.UTF-8 locale (with
UNICODE database encoding), and all is almost well, except that
UPPER() and LOWER() seem to ignore locale.
TL upper/lower
I may have missed 1.4:
PostgreSQL 7.5devel on arm-unknown-netbsdelf1.6ZE, compiled by GCC gcc (GCC) 3.3.2-nb1
but all tests work there. I didn't manage to compile bison 1.875 under
NetBSD-1.6P/acorn32, as gcc 2.95.3 really didn't like it. Upgrading to
NetBSD-1.6ZE/acorn32 upgraded to gcc 3.3.2,
Patrick Welche writes:
PostgreSQL 7.5devel on arm-unknown-netbsdelf1.6ZE, compiled by GCC gcc (GCC)
3.3.2-nb1
Can you test 7.4?
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Ryan Mahoney kirjutas N, 06.11.2003 kell 23:03:
I am running PostgreSQL 7.3.1 on i686-pc-linux-gnu, compiled by GCC 2.96
the following query fails:
SELECT 'UPDATE pa_sales_lead SET details = COALESCE(details, \'\') ||
\'' || replace(data, '\'', '\'\'') || '\' WHERE foreign_sales_lead_id =
Alexey Mahotkin kirjutas K, 05.11.2003 kell 17:11:
Aha, that's in src/backend/utils/adt/formatting.c, right?
Yes, I see, it goes byte by byte and uses toupper(). I believe we
could look at the locale, and if it is UTF-8, then use (or copy)
e.g. g_utf8_strup/strdown, right?
On Wed, Nov 05, 2003 at 09:08:31AM -0600, [EMAIL PROTECTED] wrote:
I am trying to find information regarding creation of B-tree index in postgres
for variable length character data (Char/varchar type). Specifically, what
pagination policy is used, does it use prefix BTree, or any other form
Can I get a comment from someone on this please...
LER
--On Saturday, November 08, 2003 18:03:45 -0600 Larry Rosenman
[EMAIL PROTECTED] wrote:
From my SCO contacts re: the failure on OSR5:
I haven't had time and won't have time to fully diagnose this until
after i get back from vacation.
Hannu Krosing wrote:
Ryan Mahoney kirjutas N, 06.11.2003 kell 23:03:
I am running PostgreSQL 7.3.1 on i686-pc-linux-gnu, compiled by GCC 2.96
what does just
SELECT replace(data, '\'', '\'\'')
FROM temp_sales_lead
ORDER BY id, row LIMIT 10;
produce ?
There was a bug in replace(), fixed by Tom
On Sun, 9 Nov 2003, Larry Rosenman wrote:
Can I get a comment from someone on this please...
no, the release will not be held up
LER
--On Saturday, November 08, 2003 18:03:45 -0600 Larry Rosenman
[EMAIL PROTECTED] wrote:
From my SCO contacts re: the failure on OSR5:
I
Tom Lane wrote:
Jan Wieck [EMAIL PROTECTED] writes:
However, I have not seen much evidence yet that the vacuum delay alone
does that much.
Gaetano and a couple of other people did experiments that seemed to show
it was useful. I think we'd want to change the shape of the knob per
later
scott.marlowe wrote:
On Fri, 7 Nov 2003, Matthew T. O'Connor wrote:
- Original Message -
From: Jan Wieck [EMAIL PROTECTED]
Tom Lane wrote:
Gaetano and a couple of other people did experiments that seemed to show
it was useful. I think we'd want to change the shape of the knob per
Matthew T. O'Connor wrote:
- Original Message -
From: Jan Wieck [EMAIL PROTECTED]
Tom Lane wrote:
Gaetano and a couple of other people did experiments that seemed to show
it was useful. I think we'd want to change the shape of the knob per
later suggestions (sleep 10 ms every N
| COMMENT ON LARGE OBJECT NumericOnly IS comment_text
n-objname = makeList1(makeAConst($5));
Forget the makeAConst step --- it's just wasted cycles. In the
execution routine, you can use code comparable to define.c's defGetInt64()
to convert the Value node into a numeric OID, ie, either do
I thought the whole problem here is that OIDs are unsigned ints, hence
intVal() won't allow the highest OIDs?
Exactly. That's why you need to handle T_Float too. See the int8
example, which has just the same problem.
It occurs to me then that I could just then use FloatOnly in the grammar
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
It occurs to me then that I could just then use FloatOnly in the grammar
I don't think so, unless you are proposing something very odd in the
lexer to force it to treat an integer literal as a float in this one
context.
What is the problem with
On 7 Nov 2003, Brad wrote:
I'm interested in changing the client encoding from within a java
program. I'm using connection pooling and need to change it depending
on the client's language preference. Is there a function I can call
which changes the client encoding. Something like
Tom Lane wrote:
Greg Stark [EMAIL PROTECTED] writes:
Tom Lane [EMAIL PROTECTED] writes:
You want to find, open, and fsync() every file in the database cluster
for every checkpoint? Sounds like a non-starter to me.
Except a) this is outside any critical path, and b) only done every few
Tom Lane wrote:
Jan Wieck [EMAIL PROTECTED] writes:
What still needs to be addressed is the IO storm cause by checkpoints. I
see it much relaxed when stretching out the BufferSync() over most of
the time until the next one should occur. But the kernel sync at it's
end still pushes the
scott.marlowe wrote:
On Tue, 4 Nov 2003, Tom Lane wrote:
Jan Wieck [EMAIL PROTECTED] writes:
What still needs to be addressed is the IO storm cause by checkpoints. I
see it much relaxed when stretching out the BufferSync() over most of
the time until the next one should occur. But
I would be interested to know if you have the background write process
writing old dirty buffers to kernel buffers continually if the sync()
load is diminished. What this does is to push more dirty buffers into
the kernel cache in hopes the OS will write those buffers on its own
before the
Tom Lane wrote:
Jan Wieck [EMAIL PROTECTED] writes:
That is part of the idea. The whole idea is to issue physical writes
at a fairly steady rate without increasing the number of them
substantial or interfering with the drives opinion about their order too
much. I think O_SYNC for
Tom Lane wrote:
Andrew Sullivan [EMAIL PROTECTED] writes:
On Sun, Nov 02, 2003 at 01:00:35PM -0500, Tom Lane wrote:
real traction we'd have to go back to the take over most of RAM for
shared buffers approach, which we already know to have a bunch of
severe disadvantages.
I know there
Bruce Momjian wrote:
Having another process do the writing does allow some paralellism, but
people don't seem to care of buffers having to be read in from the
kernel buffer cache, so what big benefit do we get by having someone
else write into the kernel buffer cache, except allowing a central
Bruce Momjian wrote:
Agreed, we can't resize shared memory, but I don't think most OS's swap
out shared memory, and even if they do, they usually have a kernel
configuration parameter to lock it into kernel memory. All the old
unixes locked the shared memory into kernel address space and in fact
Can you just use the SQL logging and read that file afterwords?
/djb
- Original Message -
From: Jaime Casanova [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 14:59
Subject: Re: [GENERAL] [ADMIN] [HACKERS] retrieve statement
49 matches
Mail list logo