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
t
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 plac
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.
>
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_SY
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 checkp
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 shou
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 p
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
Marcus Meissner wrote:
-- Start of PGP signed section.
> 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 currentl
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
>
>
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 wi
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
and
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
>> ... you can use code comparable to define.c's defGetInt64()
>> to convert the Value node into a numeric OID, ie, either do intVal() or
>> a call of oidin().
> I thought the whole problem here is that OIDs are unsigned ints, hence
> intVal() w
| 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 in
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
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 k
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 sugg
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:
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
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
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 for
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?
>
>
>
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_
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
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, s
> "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>
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 an
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 backu
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 guarante
> "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
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
---
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 go.
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
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
In article <[EMAIL PROTECTED]>, Lauri Pietarinen
<[EMAIL PROTECTED]> writes
>Anthony W. Youngman wrote:
>>In article <[EMAIL PROTECTED]>, Lauri Pietarinen >[EMAIL PROTECTED]> writes
>>>Anthony W. Youngman wrote:
In article <[EMAIL PROTECTED]>, Lauri Pietarinen
<[EMAIL PROTECTED]> writes
>>
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:[E
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 an
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
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
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 s
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, 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.
> >
>
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 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, ro
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
-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 of
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 conv
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(
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 == Inval
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
> >obv
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 produc
51 matches
Mail list logo
