* Yusuf Goolamabbas [EMAIL PROTECTED] [001222 15:47] wrote:
Nope, no luck with cvs -Rq also. Me thinks its some repository
permission issue. Don't know if CVSup would help either. I don't have
cvsup installed on this machine.
CVSup would work, that's what I use.
--
-Alfred Perlstein
Is there anything for encoding a PGresult struct into something I
can pass between processes? Like turning it into a platform
independant stream that I can pass between machines?
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar
committed his fixups but we're still waiting
on Vadim?
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
to specify how much deleted data you wish to
reclaim) data can be marked free but not free for re-use
until vacuum is run.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
thing
you need during high loads is the database thinking that it is time to
clean up.
Even worse is having to scan a file that has grown 20x the size
because you havne't vacuum'd in a while.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I k
want to check out:
http://people.freebsd.org/~alfred/vacfix/
It has some tarballs that have patches to speed up vacuum depending
on how you access your tables you can see up to a 20x reduction in
vacuum time.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a
increase and something too good to pass up.
thanks,
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
* xuyifeng [EMAIL PROTECTED] [001213 18:54] wrote:
I have this nasty problem too, in early time, I don't know the problem, but we used
it for a while,
than we found our table growing too fast without insert any record( we use update),
this behaviour
most like M$ MSACCESS database I had
Alfred Perlstein [EMAIL PROTECTED] -
From: Alfred Perlstein [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [HACKERS] Patches with vacuum fixes available for 7.0.x
Date: Thu, 7 Dec 2000 14:57:32 -0800
Message-ID: [EMAIL PROTECTED]
User-Agent: Mutt/1.2.5i
Sender: [EMAIL PROTECTED]
We recently
* The Hermit Hacker [EMAIL PROTECTED] [001211 14:27] wrote:
On Mon, 11 Dec 2000, Bruce Momjian wrote:
Alfred Perlstein [EMAIL PROTECTED] writes:
Basically Vadim left it up to me to campaign for acceptance of this
work and he said he wouldn't have a problem bringing it in as long
and index 641 megs.
dual 800mhz, raid 5 disks.
I think the users deserve this patch. :)
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
ave a hook where it can
eval a const because depending on the const it may or may not
be able to return a const, for instance if some string
you passed to timestamp() caused it to return non-const data.
Or maybe this is fixed in 7.1?
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I
* Tom Lane [EMAIL PROTECTED] [001207 16:45] wrote:
Alfred Perlstein [EMAIL PROTECTED] writes:
Each function should have a marker that explains whether when given
a const input if the output might vary, that way subexpressions can
be collapsed until an input becomes non-const.
We already
* Tom Lane [EMAIL PROTECTED] [001207 17:10] wrote:
Alfred Perlstein [EMAIL PROTECTED] writes:
Basically Vadim has been able to reduce the amount of time
taken by a vacuum from 10-15 minutes down to under 10 seconds.
Cool. What's it do, exactly
* Tom Samplonius [EMAIL PROTECTED] [001207 18:55] wrote:
On Thu, 7 Dec 2000, Alfred Perlstein wrote:
We recently had a very satisfactory contract completed by
Vadim.
Basically Vadim has been able to reduce the amount of time
taken by a vacuum from 10-15 minutes down to under 10
to be protected by the lock not getting flushed
out to main memory until possibly after the unlock happens.
I'm pretty sure you guys need memory barrier ops.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
: (0x3004804c) - 1
S_UNLOCK: (0x3004804d) - 1
S_UNLOCK: (0x30048048) - 1
tas (0x30048048) - 0
tas (0x3004804d) - 4
tas (0x3004804d) - 1
tas (0x3004804d) - 1
tas (0x3004804d) - 1
tas (0x3004804d) - 1
tas (0x3004804d) - 1
tas (0x3004804d) - 1
tas (0x3004804d) - 1
repeats (it's stuck)
--
-Alfred
* Tom Lane [EMAIL PROTECTED] [001205 07:14] wrote:
Alfred Perlstein [EMAIL PROTECTED] writes:
Anyhow, to address the problem I've removed struct mount from
userland visibility in both FreeBSD 5.x (current) and FreeBSD 4.x
(stable).
That might fix things on your box, but we can hardly
* Tom Lane [EMAIL PROTECTED] [001205 07:24] wrote:
Alfred Perlstein [EMAIL PROTECTED] writes:
I'm pretty sure you guys need memory barrier ops.
On a machine that requires such a thing, the assembly code for UNLOCK
should include it. Want to provide a patch?
My assembler is extremely
* Tom Lane [EMAIL PROTECTED] [001205 07:43] wrote:
Alfred Perlstein [EMAIL PROTECTED] writes:
Here's the log, the number in parens is the address of the lock,
on tas() the value printed to the right is the value in _ret,
for the others, it's the value before the lock count is set
then that chance was gone before it even happened. Hence no
reason to develop it.
*poof* no ER server.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
* Tom Lane [EMAIL PROTECTED] [001201 14:57] wrote:
Alfred Perlstein [EMAIL PROTECTED] writes:
I would rip it out.
I thought about that too, but was afraid to suggest it ;-)
I think you'd agree that you have more fun and important things to
do than to deal with this yucky interface
a computer...
http://people.freebsd.org/~alfred/images/lab.jpg
:)
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
to ignore non regular
files.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
herded, and giving up the CPU may be the best way to
do it.
Yes, but if everyone yeilds you're back where you started, and with
128 or more backends do you really want to cause possibly that many
context switches per fsync?
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I
* Tom Lane [EMAIL PROTECTED] [001116 13:31] wrote:
Alfred Perlstein [EMAIL PROTECTED] writes:
It might make more sense to keep a private copy of the last time
the file was modified per-backend by that particular backend and
a timestamp of the last fsync shared globally so one can forgo
vous point for the fsync call although
cost more as one would need to periodically call gettimeofday to
set the modified by me timestamp as well as the post-fsync shared
timestamp.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
, and they are actively porting to
more platforms.
I do feel more strongly about removing '-pipe', but it's not something I'm
going to pursue.
Why?
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
oop_unroll -Dsvr4'
$ pwd
/home/ler/pg-dev/pgsql/src/template
$
I have a patch pending for FreeBSD to support alpha builds that
also disables -m486 so if you left the freebsd template alone it
would be ok.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of
m486 -pipe'
univel:CFLAGS='-v -O -K i486,host,inline,loop_unroll -Dsvr4'
Why would you want to? Not all gccs support -mpentium/mpentiumpro etc.
The idea is to remove it entirely (I hope) not add even more arch
specific compile flags.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED
* Larry Rosenman [EMAIL PROTECTED] [001114 13:47] wrote:
* Alfred Perlstein [EMAIL PROTECTED] [001114 15:46]:
* Larry Rosenman [EMAIL PROTECTED] [001114 13:42] wrote:
Anyone care if I build a patch to kill the -m486 type options in the
following files:
$ grep -i -- 486 *
bsdi
I remeber a few developers used to gather on efnet irc,
there was a lot of instability recently that seems to have
cleared up even more recently.
Are you guys planning on coming back? Or have you all
moved to a different network?
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED
broken code when
pushed to thier highest optimization levels.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
, as always :)
Just wanted to confirm that we haven't experianced the bug since we've
applied Tom's patch several days ago.
thanks for the excellent work!
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
* Gary MacDougall [EMAIL PROTECTED] [00 11:28] wrote:
I'm trying to compile postgresql on Windows 2000. I've followed the directions
accordingly.
When I run the "configure" script, and I get the following error message:
configure: error installation or configuration problem: C
patches for the backend.
:(
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
?
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
query is a bad thing and it'd be more
prudent to wait. I have no problem syncing with your guys CVS,
but people using redhat RPMS and FreeBSD Packages are going to wind
up with this bug if you cut the release before squashing it. :(
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
, as always :)
Tom rules.
*thinking freebsd port should add user tgl rather than pgsql*
:)
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
; author: tgl; state: Exp; lines: +37 -19
Back-patch fix to ensure that VACUUM always calls FlushRelationBuffers.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
access to a FreeBSD box through the FreeBSD project and would
like to have another shot at it, but I was hoping one of the guys
more initmate with autoconf could lend me a hand.
thanks,
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in
I never saw much traffic regarding Karel's work on making stored
proceedures:
http://people.freebsd.org/~alfred/karel-pgsql.txt
What happened with this? It looked pretty interesting. :(
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I
://people.freebsd.org/~alfred/karel-pgsql.txt
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
might be too awkward? Any hints?
Set your umask to 777 then go to town.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
* Oliver Elphick [EMAIL PROTECTED] [001018 04:59] wrote:
Bruce Momjian wrote:
Alfred Perlstein wrote:
I noticed that INHERITS doesn't propogate indecies, It'd be nice
if there was an toption to do so.
Yep it would. Are you volunteering?
Added to TODO
this wasn't
a completely isolated incident.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
* Mikheev, Vadim [EMAIL PROTECTED] [001016 09:33] wrote:
I don't understand why WAL needs to log internal operations of any of
the index types. Seems to me that you could treat indexes as black
boxes that are updated as side effects of WAL log items for heap tuples:
when adding a heap tuple
ve the system tables broken, however the chances
of that may be siginifigantly reduced depending on how often writes
must be done to them.
It's a hack, but depending on the amount of writes done to critical
tables it may reduce the window for these inconvient situations
signifigantly.
--
-Alfred
these signals or shutting
down cleanly on reciept of them?
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
* Tom Lane [EMAIL PROTECTED] [001012 12:14] wrote:
Alfred Perlstein [EMAIL PROTECTED] writes:
I'm pretty sure I know what to do now, it's pretty simple actually,
I can examine the state of the connection, if it's in PGASYNC_COPY_IN
then I don't grow the buffer, I inform the application
At times I need to call PQendcopy, how to I determine that it won't
block me waiting for output from the backend?
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
ttr()',
is there anything I can do to provide more comprehensive error
reporting or something?
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
,
-Alfred
- Forwarded message from Alfred Perlstein [EMAIL PROTECTED] -
From: Alfred Perlstein [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Tom Lane [EMAIL PROTECTED]
Subject: [HACKERS] more crashes
Date: Mon, 2 Oct 2000 15:17:12 -0700
Message-ID: [EMAIL PROTECTED]
User-Agent: Mutt/1.2.4i
X
afe without doing surgery on those files.)
gcc supports the '-include' directive which may be what you want.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
7316
(gdb) print *value
Cannot access memory at address 0x3ff39254.
(gdb) print oids
$7 = 0 '\000'
(gdb) print binary
$8 = 0 '\000'
(gdb) print string
$9 = 0xfffc Address 0xfffc out of bounds
Now I think I have the intial spot where it all goes to pot (the
initial traceback). I rea
.
Check this out, I'm sure your contribution can help realize the
replication server.
http://www.pgsql.com/press/PR_5.html
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
* Bruce Momjian [EMAIL PROTECTED] [000929 19:30] wrote:
Can someone remind me of where we left this?
I really haven't figured a correct way to deal with the output buffer.
I'll try to consider ways to deal with this.
-Alfred
* [EMAIL PROTECTED] [EMAIL PROTECTED] [000926 02:33] wrote:
Hello,
I recently spoke about extending index scan to be able
to take data directly from index pages.
[snip]
Is someone interested in this ??
Considering the speedup, I sure as hell am interested. :)
When are we going to have
101 - 159 of 159 matches
Mail list logo