with solutions to problems that will occur in near future..
;-)
17 hours! Ouch. Either way, you should be able to do much better. Hope this
helps,
--
Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/
There are 10 kinds of people in the world, those that can do binary
arithmetic
can only be used left to right. This is where a single
multicolumn index differs from multiple indexes of different columns.
Have you used EXPLAIN ANALYSE to determine whether your indexes are being
used optimally?
--
Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog
the log: ...
These docs seem to corrobrate this.
So, with Pg, if you backup your db every night with pg_dump, and your
server crashes during the day, you will loose up to one day of work.
I've never lost any data with postgres, even if it's crashed, even without
WAL.
--
Martijn van Oosterhout
in the length are already used (IIRC) for other
things making it a bit more tricky.
--
Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/
There are 10 kinds of people in the world, those that can do binary
arithmetic and those that can't.
---(end
.
--
Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/
There are 10 kinds of people in the world, those that can do binary
arithmetic and those that can't.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http
declare a cursor it
doesn't run the query yet. You have to tell it to run the query before it
can tell you how many rows it is. I think the command is MOVE.
--
Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/
Support bacteria! They're the only culture some people have
just be filled in while
reading.
Unless I'm misunderstanding its purpose.
--
Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/
Canada, Mexico, and Australia form the Axis of Nations That
Are Actually Quite Nice But Secretly Have Nasty Thoughts About America
the situation? I've been
looking into it a bit recently so I think I may be able to whip something
useful up.
Thanks in advance,
--
Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/
Canada, Mexico, and Australia form the Axis of Nations That
Are Actually Quite Nice
On Sun, Apr 21, 2002 at 03:46:07PM +0900, Curt Sampson wrote:
On Sat, 20 Apr 2002, Tom Lane wrote:
Martijn van Oosterhout [EMAIL PROTECTED] writes:
2. If not, would patches be accepted to correct the situation?
Go for it.
Yes, please! I'd be happy to review and updated version.
Ok
On Mon, Apr 22, 2002 at 11:14:36AM -0500, Ross J. Reedstrom wrote:
On Sun, Apr 21, 2002 at 07:28:32PM +1000, Martijn van Oosterhout wrote:
http://svana.org/kleptog/pgsql/page.sgml.txt
I don't know whatever SGML format this is using, so the layout is not great,
but the information
On Tue, Apr 23, 2002 at 09:15:22AM +0200, Hannu Krosing wrote:
On Tue, 2002-04-23 at 01:29, Martijn van Oosterhout wrote:
The dumping is more of an extra, the original idea was to check for errors
in the datafiles. Hence the working name of pgfsck. At the moment the
dumping dumps only
versions have a strange layout. You may get many
harmless warnings about the formats of pg_class, pg_attribute and/or pg_type.
Most of these are basically because I don't know how they work, but with a
bit of work some of these should be fixable.
Have a nice day,
--
Martijn van Oosterhout [EMAIL
to 2TB (2^32 x 512bytes),
probably much more. What about the BSDs? XFS? etc
--
Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/
There are 10 kinds of people in the world, those that can do binary
arithmetic and those that can't.
---(end of broadcast
in a year or two.
--
Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/
There are 10 kinds of people in the world, those that can do binary
arithmetic and those that can't.
---(end of broadcast)---
TIP 2: you can get off all
, not the patch itself. Sorry for the confusion.
Tom actually suggested doing this at the same time as re-enabling partial
indices but I favoured a separate patch considering the large number of
scattered changes.
Anyway, is there a concensus, or shall I forget the whole thing?
--
Martijn van
.
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://svana.org/kleptog/
It would be nice if someone came up with a certification system that
actually separated those who can barely regurgitate what they crammed over
the last few weeks from those who command secret ninja networking powers
the switch with a
function call.
Any thoughts?
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://svana.org/kleptog/
It would be nice if someone came up with a certification system that
actually separated those who can barely regurgitate what they crammed over
the last few weeks from those who command
' LANGUAGE 'C';
How can I determine I'm supposed to return a mytype? I'm running 7.4
if it matters...
Thanks in advance,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5
[Please CC replies, thanks]
On Thu, Aug 11, 2005 at 02:17:30PM -0400, Tom Lane wrote:
Martijn van Oosterhout kleptog@svana.org writes:
What I'm trying to do now is use fcinfo-flinfo-fn_oid to lookup
pg_proc and get the return type from there, but something tells me
there must be an easier
arguments except C. It can be added if you think it's worth
regression testing.
Unless there are other comments I'll post this to pgsql-patches
later...
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration
Forgot to attach it, oops.
On Fri, Aug 12, 2005 at 09:56:47AM +0200, Martijn van Oosterhout wrote:
Ok, here's a patch (with documentation update). I checked the
regression tests (looked over, not run) but nothing there appears to
test this anyway. I looked through all the datatype input
to detect if a snapshot has been started and creating
one if there hasn't. I've seen the snapshot related functions but I
don't feel comfortable sticking them in my type input function just to
fix this. Is it safe?
Thanks in advance,
--
Martijn van Oosterhout kleptog@svana.org http
On Sat, Aug 13, 2005 at 12:36:42PM -0400, Tom Lane wrote:
Martijn van Oosterhout kleptog@svana.org writes:
- Is there a way to detect if a snapshot has been started and creating
one if there hasn't. I've seen the snapshot related functions but I
don't feel comfortable sticking them in my
at 03:59:56PM +0200, Martijn van Oosterhout wrote:
Good guess, I am inside a type input function trying to use SPI. My
questions are:
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5
function be accepted?
Have a nice day,
[1] http://archives.postgresql.org/pgsql-hackers/2004-06/msg00923.php
[2] http://archives.postgresql.org/pgsql-hackers/2004-06/msg00932.php
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95
a nice day,
On Sat, Aug 27, 2005 at 11:09:09AM -0400, Tom Lane wrote:
Martijn van Oosterhout kleptog@svana.org writes:
Tom Lanes patch[2] looks like it may work, but would a mechanism to
allow user-defined types to have a typmod function be accepted?
[2] http://archives.postgresql.org/pgsql
set value = value + 10 where grp = 'a'
2e update t set value = value + 10 where grp = 'a'
1 commit
2 wait
2 abort
1 drop table t
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5
this be allowed?
Should aliasing for DEC and DECIMAL - NUMERIC be done for
user-defined types?
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work
the easy way and implement
the slightly more difficult if it turns out the be necessary.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work
.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them
, I fear.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them
and
should they default to typmod -1? Currently '()' is not even accepted.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting
confused
by some of the things they'd added. Am I the only one?
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do
On Thu, Sep 01, 2005 at 08:50:27AM -0400, Tom Lane wrote:
Martijn van Oosterhout kleptog@svana.org writes:
Simply pass the (Node*) from the parser and let the function sort it
out itself. Except now they have to be written in C. Is this
unreasonable,
Nope. You're not going to be writing
-
test1
Tést1
Tëst1
Test2
tèst2
(5 rows)
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95
On Thu, Sep 01, 2005 at 01:46:00PM -0400, Tom Lane wrote:
Martijn van Oosterhout kleptog@svana.org writes:
1. Is something supported by glibc usable for us (re portability to
non-glibc platforms)?
Nope. Sorry.
Do we have some platforms that don't have any multi-language support? I
mean
Method finding encoding for nl_langinfo_l ???
locale
strcoll with locale parameter strcoll_l _strcoll_l
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5
On Fri, Sep 02, 2005 at 03:04:20PM +0200, Martijn van Oosterhout wrote:
Supports any glibc platform and possibly Win32.
MacOS X [1] supports this also apparently. And for glibc it appears to
have been accepted as part of the API since 2.3.2 and formally accepted
into LSB3.0. Win32 claims to have
(s1, s2)
const char *s1, *s2;
{
_DIAGASSERT(s1 != NULL);
_DIAGASSERT(s2 != NULL);
/* LC_COLLATE is unimplemented, hence always C */
return (strcmp(s1, s2));
}
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5
if there could be some real movement.
Have a nice weekend,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so
van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them.
pgpY0njaqfLIH.pgp
Description: PGP
://icu.sourceforge.net/) will end up obsoleting us. Nobody (in
free-software anyway) uses it yet, but eventually it may be viable to
require that to allow system independant locales.
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95
close. From here
on I'm going to work on COLLATE for systems that support xlocale, with
an eye on ICU if/when it becomes standard enough.
Download: http://svana.org/kleptog/pgsql/dummylocale.tar.gz
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n
but rather than
just changing them all, is there a particular phase where these changes
are made that I should be looking at?
Thanks in advance,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool
On Tue, Sep 06, 2005 at 03:51:41PM +, Matt Miller wrote:
On Tue, 2005-08-30 at 00:56 +0200, Martijn van Oosterhout wrote:
http://svana.org/kleptog/pgsql/mvcctest.tar.gz
I've started using it in some simple cases and it seems to be a good
tool. The feature set looks to me to be a pretty
think operators might have some more.
Personally, when I want to add a field to a node, I grep for every
reference to one or two of the existing fields to make sure I've found
all the places I need to touch.
So there's no shortcut, I'll remember that :)
Thanks for the help,
--
Martijn van
://svana.org/kleptog/pgsql/sql2install.pl
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can
://gborg.postgresql.org/project/citext/projdisplay.php
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you
catalog with an old one...
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them
:
{
global:
pg_finfo_*
other exported symbols
local: *
}
Whether it's enough... For people who want to know the gory details,
read this (by Ulrich Drepper).
http://people.redhat.com/drepper/dsohowto.pdf
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n
,
Michael.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5
of the issues don't
apply. My main concern is how you even detect the number of processors
in a portable way...
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5
class...
Definitly 8.2 stuff, and it's not simple stuff either...
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else
.
It's not easy, like you say, there are a lot of places where an extra
argument would need to be passed...
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work
bit to a and b before passing it to
the '' operator. An index can only support one collation at a time
also.
I don't think there is an easy way out...
[1] http://svana.org/kleptog/pgsql/taggedtypes.html
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius
the operator after USING to
be part of an operator class?
Have a nice day,
[1] http://www.postgresql.org/docs/8.0/interactive/queries-order.html
[2] http://www.postgresql.org/docs/8.0/interactive/sql-select.html
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n
.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them
was, what was the solution he was referring to using
the USING clause?
[1] http://lafstern.org/matt/col2_new.pdf
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work
''.
That's my thought. However, the code doesn't seem to restrict you to
that so I was wondering if there was any other use out there that we
should consider supporting...
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration
to dealt with somewhere else,
given that it's unrelated to order.
This is going way out of spec though...
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting
that
usable operators have two arguments and IS NULL isn't really an
operator in the PostgreSQL sense and doesn't have two arguments either.
*If* that can be fixed, then we can be more flexible. But if it were
easy it would have been done long ago...
Have a nice day,
--
Martijn van Oosterhout
much discussion on collation and ordering
I'm going to take from this discussion that there is no use for the
USING clause with operators not in an operator class and that if this
changes we won't be seriously inconveniencing anybody.
Have a nice day,
--
Martijn van Oosterhout kleptog
by the backend and passed each call? At the moment
there is some discussion on changes to the index interface so now is
the time to ask for what you want...
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent
it's needed for to know
if that's a problem...
So even if an index can store the parameter itself, there would need to
be a way for pg_dump to extract it.
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent
will have a partitioning system
based upon it.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do
into issues with data interleaved, meaning not much to give back to the
OS...
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
?
Tricky issues...
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them
postgres with a new stack; that preserves existing
semantics.
Signals are the only way the kernel can pass control unexpectedly so if
you handle those, postgres would never know it's threaded. I do wonder
if there are any other assumptions made...
Have a nice day,
--
Martijn van Oosterhout kleptog
On Sat, Sep 24, 2005 at 02:38:35PM +0200, Thomas Hallgren wrote:
Martijn van Oosterhout wrote:
Linux has sigaltstack so you can catch the stack overflow signal (and
other signals obviously, but that's its main use), but it's not terribly
portable.
I rely on the signal handler
*
from pg_proc and there are no multiple characters there AFAIK. I can't
see it though.
Hope this helps,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work
On Sat, Sep 24, 2005 at 11:45:08PM +0200, Martijn van Oosterhout wrote:
Hi,
On CVS tip, whenever I do \x output, it dies with an internal error in
glibc on free. If you run it under valgrind, it complains about these
lines of code:
snip
Ok, I worked out the direct cause, pg_wcswidth only
the
only case psql handles differently. I've attached a patch which fixes
it. With a bit more rearrangement you could probably simplify it a bit
but this works.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95
--
\x08
(1 row)
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them
earlier
than that.
If you really need this to work, I suggest pulling the libpq from that
release (CVS or tarball) or slightly later and installing that on the
new machines.
But you should upgrade, 6.4 hasn't had support for year, who know how
many bugs...
--
Martijn van Oosterhout kleptog
it since whatever displays the HTML will take care of alignment.
Same for troff and CSV. Straight aligned text output is the only one we
care about AFAICS (and the only one that requires work to make it
happen).
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org
I made up. (Real data has a
habit of showing weaknesses far better than things you dream up). But
I'll give it a shot.
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work
, it is a fairly unusual feature.
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them
missing something?
Isn't this what adddepend was for? I can beleive there are version
dependancies here...
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work
: error code 10038
That's from postmaster.c:write_inheritable_socket(). Error 10038 is
WSAENOTSOCK. Very odd, time to get out the debugger? Get a backtrace at
least.
Hope this helps,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95
need to.
http://www.postgresql.org/docs/8.0/interactive/xfunc-c.html#AEN30497
Now, you could fudge the parser to automatically alter the name of the
value in the function but I'm have no idea how hard that would be...
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent
(1). The latter is
variable length and can store any character per current encoding, hence
the variable length. char on the other hand is a one byte (presumably
ASCII) character. It's used mainly in the system catalogs...
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog
be a general solution to the problem.
This is what Constraint Exclusion does. It uses CHECK constraints on
a table to filter out tables that obviously don't apply to a query.
It's just the the specific case of tableoid = XXX is not supported
right now.
Have a nice day,
--
Martijn van Oosterhout
is
probably CPU bound more than anything else.
So, I don't think physical I/O is the problem. It's something further
up the call tree. I wouldn't be surprised at all it it had to do with
the creation and destruction of tuples. The cost of comparing tuples
should not be underestimated.
--
Martijn van
the project_id.
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them
0.97505.83 6.17 23711355 0.00 0.00 AllocSetFreeIndex
0.84511.19 5.36 5920596 0.00 0.00 LogicalTapeWrite
0.84516.51 5.33 2960314 0.00 0.00 slot_deform_tuple
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n
On Sat, Oct 01, 2005 at 11:26:07PM -0400, Tom Lane wrote:
Martijn van Oosterhout kleptog@svana.org writes:
Anyway, to bring some real info I just profiled PostgreSQL 8.1beta
doing an index create on a 2960296 row table (3 columns, table size
317MB).
3 columns in the index you mean? What
for new values but not for old ones. That wouldn't work if
the database starts adding values randomly, depending on when they are
read...
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent
.
The documentation isn't totally clear about this. Yet the error thrown
should terminate the process, yet it obviously isn't. Very odd.
Any Windows programmers with ideas?
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95
.
Basically, I recommend adding -Winline -finline-limit-1500 to the
default build while we discuss other options.
comparetup_index_fastbyval4 patch attached per example.
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration
default which can be changed anytime?
Seems messy, though possible...
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting
usage. Besides, seems to me it should be an system admisitrator
descision.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting
day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them.
pgpWTkP5cRja6.pgp
who to kill. Sometimes you just get unlucky...
It's always killed the right process for me (Mozilla derivative leaked
masses of memory over long period).
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent
On Tue, Oct 04, 2005 at 12:37:51AM +0100, Simon Riggs wrote:
On Mon, 2005-10-03 at 23:25 +0200, Martijn van Oosterhout wrote:
Please note: if inlineApplySortFunction() is actually inlined (it isn't
by default)
Can you explain your last post some more. Thats not what I get.
The inline
van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them.
pgppgbguCvZK1.pgp
Description: PGP
On Tue, Oct 04, 2005 at 11:55:58AM +0200, Martijn van Oosterhout wrote:
It goes in to say that the limit is 1 for gcc 2.95, but if you
examine the manual for gcc 3.3 it has the limit at 600. So it's
entirely possible that at the time the person wrote that code, it *was*
being inlined
and
CLOBBER_FREED_MEMORY) which can help find leaks. Valgrind works too,
with a bit of attention. I was going to add some directives to allow
Valgrind to handle PostgreSQL's memory allocator, but have got there
yet.
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5
a nice round number, 1500.
Ugh, that's for -O2, for -O3 and above it needs to be 4100 to work.
Maybe we should go for 5000 or so.
I'm using: gcc (GCC) 3.3.5 (Debian 1:3.3.5-13)
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5
On Tue, Oct 04, 2005 at 10:06:24AM -0400, Tom Lane wrote:
Martijn van Oosterhout kleptog@svana.org writes:
I'm using: gcc (GCC) 3.3.5 (Debian 1:3.3.5-13)
I don't know what the units of this number are, but it's apparently far
too gcc-version-dependent to consider putting into our build
whether we want to go down the path of hinting to gcc which
size will be the most common.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work
1 - 100 of 1563 matches
Mail list logo