Re: [HACKERS] vacuum, performance, and MVCC

2006-06-24 Thread Martijn van Oosterhout
(5) Attempt to index the row (6) If the first version of the row is in the index already (ver001) Don't modify the index, otherwise, add the new version (just as before) This looks OK, I guess. I wouldn't know about locking... Have a nice day, -- Martijn van Oosterhout kleptog@svana.org

Re: [HACKERS] vacuum, performance, and MVCC

2006-06-24 Thread Martijn van Oosterhout
referenced key value does not change. I think we recently changed the code to always scan an index a page at a time so maybe scans no longer stop in the middle of a page anymore... Or perhaps that was VACUUM only. Have a noce day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog

Re: [HACKERS] Shared library conflicts

2006-06-23 Thread Martijn van Oosterhout
there's a filter command to strip libraries not needed. One of them is libz. From src/backend/Makefile: # The backend doesn't need everything that's in LIBS, however LIBS := $(filter-out -lz -lreadline -ledit -ltermcap -lncurses -lcurses, $(LIBS)) Have a nice day, -- Martijn van Oosterhout

Re: [HACKERS] Planning without reason.

2006-06-23 Thread Martijn van Oosterhout
to create a plan for SPI. 10x. I imagine SPI_prepare() and SPI_execp() would be used for this. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description

Re: [HACKERS] vacuum, performance, and MVCC

2006-06-23 Thread Martijn van Oosterhout
addressed... Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [HACKERS] Planning without reason.

2006-06-23 Thread Martijn van Oosterhout
arguments, thus you could push them straight to SPI_execp(). But you seem to be suggesting parts of the actual query are in datum form also? Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability

Re: [HACKERS] Webcluster session storage, was vacuum, performance, and MVCC

2006-06-23 Thread Martijn van Oosterhout
version that used the Postgres buffer cache and file management. Another possibility is something like tdb. Basically, I'm not sure what all of this has to do with the core goal of Postgres, which is to be an SQL compliant database. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org

Re: [HACKERS] Planning without reason.

2006-06-23 Thread Martijn van Oosterhout
On Fri, Jun 23, 2006 at 06:10:33PM +0300, Tzahi Fadida wrote: On Friday 23 June 2006 17:47, Martijn van Oosterhout wrote: On Fri, Jun 23, 2006 at 05:12:14PM +0300, Tzahi Fadida wrote: My initial reasoning was to avoid extra sorts but i guess that the planner just doesn't get the LIMIT 1

Re: [HACKERS] Planning without reason.

2006-06-23 Thread Martijn van Oosterhout
wouldn't apply anyway (otherwise it could be done by hand). Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [HACKERS] trivial DoS on char recoding

2006-06-21 Thread Martijn van Oosterhout
this test is so unreliable we won't even emit a warning... [1] http://www.haible.de/bruno/packages-libcharset.html Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate

Re: [HACKERS] Generic Monitoring Framework Proposal

2006-06-20 Thread Martijn van Oosterhout
that with an illegal instruction or the special one-byte INT3 instruction x86 system have for this purpose. With a 17-stage pipelined processor I imagine the cost of a no-op would indeed be almost unmeasurable (increase code size I suppose). Have a nice day, -- Martijn van Oosterhout kleptog

Re: [HACKERS] shall we have a TRACE_MEMORY mode

2006-06-20 Thread Martijn van Oosterhout
of context over 10 MB ) dump_stack_trace() Ofcourse, you might just miss the allocations you need to look at... The backtrace_symbols_fd() function dumps straight to a file, if you want to avoid cluttering up the logs. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http

Re: [HACKERS] regresssion script hole

2006-06-19 Thread Martijn van Oosterhout
is there or elsewhere... Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [HACKERS] Exporting type OID macros in a cleaner fashion

2006-06-17 Thread Martijn van Oosterhout
it. pgtypeoids.h sounds like a good name to me and it should be in the top level. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital

Re: [HACKERS] Re-thing PG_MODULE_MAGIC

2006-06-16 Thread Martijn van Oosterhout
or ascertain. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [HACKERS] Re-thing PG_MODULE_MAGIC

2006-06-16 Thread Martijn van Oosterhout
doing can't possibly work. To override malloc/free, you need to load the library *before* the C library. Having the postmaster do it after startup is way too late. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability

Re: [HACKERS] Increasing catcache size

2006-06-15 Thread Martijn van Oosterhout
pg_class into the catcache? Your suggestion sounds like a good one... Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [HACKERS] postgresql and process titles

2006-06-14 Thread Martijn van Oosterhout
we want SIGPROF, SIGALRM or SIGVTALRM? There's apparently a distinction, see: http://en.wikipedia.org/wiki/SIGPROF Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate

Re: [HACKERS] CSV mode option for pg_dump

2006-06-14 Thread Martijn van Oosterhout
what you're asking here... Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [HACKERS] CSV mode option for pg_dump

2006-06-14 Thread Martijn van Oosterhout
'\copy pg_namespace to stdout csv' pg_toast,10, pg_temp_1,10, pg_catalog,10,{kleptog=UC/kleptog,=U/kleptog} public,10,{kleptog=UC/kleptog,=UC/kleptog} information_schema,10,{kleptog=UC/kleptog,=U/kleptog} Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog

Re: [HACKERS] postgresql and process titles

2006-06-14 Thread Martijn van Oosterhout
the situation. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [HACKERS] libpq's pollution of application namespace

2006-06-14 Thread Martijn van Oosterhout
pgresStatus Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [HACKERS] libpq's pollution of application namespace

2006-06-14 Thread Martijn van Oosterhout
was that it wasn't worth it. That's my recollection too. I had something that supported HPUX for example but it was decided not worth the effort (can't find it right now though...). Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability

Re: [HACKERS] longjmp in psql considered harmful

2006-06-13 Thread Martijn van Oosterhout
programs that included print.c would only ever see zero in that variable. Maybe some other arrangement is possible. Maybe like you suggest, declare the symbol in print.c and make the declaration in common.c an extern. The end result is the same though. Have a nice day, -- Martijn van Oosterhout

Re: [HACKERS] Running a query twice to ensure cached results.

2006-06-13 Thread Martijn van Oosterhout
a write? Have a ncie day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [HACKERS] timezones to own config file

2006-06-13 Thread Martijn van Oosterhout
they also be read at SIGHUP? If so, should they be read only by the postmaster or by all backends? Good question... Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate

Re: [HACKERS] Running a query twice to ensure cached results.

2006-06-13 Thread Martijn van Oosterhout
On Tue, Jun 13, 2006 at 05:46:23AM -0700, Luke Lonergan wrote: Martin, On 6/13/06 5:42 AM, Martijn van Oosterhout kleptog@svana.org wrote: Is it possible it may have something to do with the hint bits? There's are a bunch of bits in the header to deal with speeding up of MVCC tests

Re: [HACKERS] CSV mode option for pg_dump

2006-06-13 Thread Martijn van Oosterhout
of this is an issue in the first place. Have a ncie day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [HACKERS] postgresql and process titles

2006-06-13 Thread Martijn van Oosterhout
there. And ofcourse it's an almost guarenteed loss on systems that don't require a syscall to set the proc title. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc

Re: [HACKERS] timezones to own config file

2006-06-13 Thread Martijn van Oosterhout
On Tue, Jun 13, 2006 at 11:51:25AM -0400, Tom Lane wrote: Martijn van Oosterhout kleptog@svana.org writes: Any particular reason this can't be a normal table in pg_catalog which you can select/update. That doesn't do anything to help with one of the main problems: that we have at least

Re: [HACKERS] longjmp in psql considered harmful

2006-06-11 Thread Martijn van Oosterhout
it there? Have a ncie day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [HACKERS] longjmp in psql considered harmful

2006-06-11 Thread Martijn van Oosterhout
On Sun, Jun 11, 2006 at 02:08:12PM -0400, Tom Lane wrote: Martijn van Oosterhout kleptog@svana.org writes: On Sun, Jun 11, 2006 at 12:32:22PM -0400, Tom Lane wrote: I think we should try very hard to get rid of the longjmp in the signal handler altogether. I submitted a patch

Re: [HACKERS] Ranges for well-ordered types

2006-06-11 Thread Martijn van Oosterhout
, this probably would've been done already. Fix that, and the index itself will appear shortly afterwards... Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc

Re: [HACKERS] longjmp in psql considered harmful

2006-06-11 Thread Martijn van Oosterhout
On Sun, Jun 11, 2006 at 02:57:38PM -0400, Tom Lane wrote: Martijn van Oosterhout kleptog@svana.org writes: As it states in the comment, you can't remove the longjump because it's the only way to break out of the read() call when using BSD signal semantics (unless you're proposing non

Re: [HACKERS] longjmp in psql considered harmful

2006-06-11 Thread Martijn van Oosterhout
On Sun, Jun 11, 2006 at 03:23:50PM -0400, Tom Lane wrote: Martijn van Oosterhout kleptog@svana.org writes: If you're asking me, yes. I use it a lot and would miss it if it were gone. Is there another shortcut for abort current command and don't store in history but don't clear it from

Re: [HACKERS] How to avoid transaction ID wrap

2006-06-10 Thread Martijn van Oosterhout
alternative) that scales with D, O^k(D) where any k 1 involves a tradeoff with VACCUM. That's why people suggest partitions. Then you only vacuum the partitions that are new and the old ones never need to be touched... Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org

Re: [HACKERS] Latest timezone data in 8.1.4

2006-06-10 Thread Martijn van Oosterhout
backends. For existing ones probably not. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [HACKERS] That EXPLAIN ANALYZE patch still needs work

2006-06-09 Thread Martijn van Oosterhout
, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [HACKERS] That EXPLAIN ANALYZE patch still needs work

2006-06-09 Thread Martijn van Oosterhout
have to recompile to get the option you want. Right now I'm confused though. I was under the impression the changes were going to be ripped out because it was decided to be unworkable. I think improvements can be made but I'm unsure if there's any interest... Have a nice day, -- Martijn van

Re: [HACKERS] List schema contents

2006-06-09 Thread Martijn van Oosterhout
.*? The only irritating thing is that is only displays table, not other objects... Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [HACKERS] That EXPLAIN ANALYZE patch still needs work

2006-06-09 Thread Martijn van Oosterhout
if it doesn't match real time. This puts us back to CPU cycle counters, but they have drawbacks of their own. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate

Re: [HACKERS] How to avoid transaction ID wrap

2006-06-07 Thread Martijn van Oosterhout
now I don't think those commodoties are cheap enough to use like this for fairly marginal benefits. Beside, memory bandwidth hasn't grown anywhere enar as fast as memory space, so it's always a good idea to use as little memory as possible. Have a nice day, -- Martijn van Oosterhout kleptog

Re: [HACKERS] That EXPLAIN ANALYZE patch still needs work

2006-06-07 Thread Martijn van Oosterhout
how much time was spent in each node, but you no longer have any idea about when they were entered or left. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc

Re: [HACKERS] That EXPLAIN ANALYZE patch still needs work

2006-06-07 Thread Martijn van Oosterhout
| perl -lne 'BEGIN { $last=0; $sum =0 } /: (\d+) usec in iter (\d+)/ do { $sum += ($2-$last)*$1; $last=$2 }; END { print $sum\n }' I propose we revert this patch and think about an interrupt-driven sampling method instead. That's another possibility ofcourse... -- Martijn van Oosterhout

Re: [HACKERS] That EXPLAIN ANALYZE patch still needs work

2006-06-07 Thread Martijn van Oosterhout
On Wed, Jun 07, 2006 at 04:04:33PM -0400, Tom Lane wrote: Martijn van Oosterhout kleptog@svana.org writes: Anyway, as a test, if you take the approach that the measurement at item X only applies to the tuples immediately preceding it, for the data you posted you get a result of 0.681148

Re: [HACKERS] That EXPLAIN ANALYZE patch still needs work

2006-06-06 Thread Martijn van Oosterhout
it guesses. SampleOverhead would be good too. I know my version produced sensible results on my machine and the handful of people testing, so I'll try it again with your changes, see how it looks... Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each

Re: [HACKERS] adding new field

2006-06-06 Thread Martijn van Oosterhout
query, got results. 3. Next, I uncommented that part, and ran the same query again. I GOT THE RESULTS. Did you rerun make install and restart the postmaster between each run? Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his

Re: [HACKERS] That EXPLAIN ANALYZE patch still needs work

2006-06-06 Thread Martijn van Oosterhout
suggest a much more careful correction method that works for non-linear timing patterns... Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description

Re: [HACKERS] adding new field

2006-06-05 Thread Martijn van Oosterhout
this helps, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [HACKERS] CTID issues and a soc student in need of help

2006-06-01 Thread Martijn van Oosterhout
using it for. Hope this helps, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [HACKERS] Generalized concept of modules

2006-06-01 Thread Martijn van Oosterhout
On Wed, May 31, 2006 at 05:33:44PM -0400, Tom Lane wrote: Martijn van Oosterhout kleptog@svana.org writes: While you do have a good point about non-binary modules, our module handling need some help IMHO. For example, the current hack for CREATE LANGUAGE to fix things caused by old pg_dumps

Re: [HACKERS] [PATCHES] Magic block for modules

2006-05-31 Thread Martijn van Oosterhout
the breakage more concentrated. At the very least it ought to be a WARNING immediately, because a LOG message is just not visible enough. If you like I can send a patch that adds it to all of contrib and some of the other places required so that make check passes... Have a nice day, -- Martijn van

Re: [HACKERS] plperl's ppport.h out of date?

2006-05-31 Thread Martijn van Oosterhout
a slimmed-down copy of the up-to-date output. Not sure whether it's worth it, but this sed line strips the POD docs: sed -e '/^=/,/^=cut/d' ppport.h Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according

Re: [HACKERS] Possible TODO item: copy to/from pipe

2006-05-31 Thread Martijn van Oosterhout
, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [HACKERS] Possible TODO item: copy to/from pipe

2006-05-31 Thread Martijn van Oosterhout
On Wed, May 31, 2006 at 11:20:21PM +0200, Magnus Hagander wrote: Uh. The installer does *not* include readline. Terribly sorry, I misinterpreted the thread about it at the beginning of the year. http://archives.postgresql.org/pgsql-hackers/2006-02/msg00539.php Have a nice day, -- Martijn van

Re: [HACKERS] 64bit build vs 32 bit build

2006-05-30 Thread Martijn van Oosterhout
, no effort has been put into making it work... Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [HACKERS] anoncvs still slow

2006-05-30 Thread Martijn van Oosterhout
, the posts just have to be approved. How would we still do that? I'm assuming we're talking about a list of valid To: addresses, not From: addresses. That list should be fairly short... Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according

Re: [HACKERS] LIKE, leading percent, bind parameters and indexes

2006-05-29 Thread Martijn van Oosterhout
On Sat, May 27, 2006 at 11:52:40AM -0400, Tom Lane wrote: Martijn van Oosterhout kleptog@svana.org writes: How about the suggestion of using a sequential index scan like the recent changes to VACUUM in the case that there are no regular index quals? Nonstarter (hint: the solution we

[HACKERS] Error in recent pg_dump change (coverity)

2006-05-28 Thread Martijn van Oosterhout
for people watching at home. -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [HACKERS] Error in recent pg_dump change (coverity)

2006-05-28 Thread Martijn van Oosterhout
catch a few more problems of the same ilk. Probably better actually, since by setting ntups to zero also, PQgetvalue will return a warning (row number out of range) rather than segfaulting... Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each

Re: [HACKERS] LIKE, leading percent, bind parameters and indexes

2006-05-28 Thread Martijn van Oosterhout
. You could then have whatever you want between them, perhaps deferring the fetch step until just before returning the rows to the client. That's kinda what a bitmap scan does. Although, we never fetch tuples unless you're going to use the result in some way... Have a nice day, -- Martijn van

Re: [HACKERS] LIKE, leading percent, bind parameters and indexes

2006-05-27 Thread Martijn van Oosterhout
scan like the recent changes to VACUUM in the case that there are no regular index quals? Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description

Re: [HACKERS] Inefficient bytea escaping?

2006-05-27 Thread Martijn van Oosterhout
in. Ofcourse, it takes a few cycles to determine that, but I don't think that'd cause a major slowdown. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc

Re: [HACKERS] Inefficient bytea escaping?

2006-05-27 Thread Martijn van Oosterhout
On Sat, May 27, 2006 at 08:23:35PM +0300, Marko Kreen wrote: On 5/27/06, Martijn van Oosterhout kleptog@svana.org wrote: Given there is no way to know if you're running single threaded or not, I don't think glibc can take chances like that. There's CPP symbol _REENTRANT for that and in run

Re: [HACKERS] v814 + OSX10.4.6 builds OK, but fails launch ...

2006-05-26 Thread Martijn van Oosterhout
machine (linux) won't let me change them anyway, it changes the bits on the underlying file. Is OSX different here? Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate

Re: [HACKERS] timezones to own config file

2006-05-26 Thread Martijn van Oosterhout
users can customise... Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [HACKERS] Bug with UTF-8 character

2006-05-26 Thread Martijn van Oosterhout
On Fri, May 26, 2006 at 05:16:59PM +0300, Marko Kreen wrote: On 5/26/06, Martijn van Oosterhout kleptog@svana.org wrote: On Fri, May 26, 2006 at 08:21:56AM +0200, Hans-Jürgen Schönig wrote: I got a bug request for the following unicode character in PostgreSQL 8.1.4: 0xedaeb8 ERROR

Re: [HACKERS] Updatable views/with check option parsing

2006-05-26 Thread Martijn van Oosterhout
CREATE VIEW foo AS SELECT expr :: TIME WITH CHECK OPTION -- parse error CREATE VIEW foo AS SELECT (expr :: TIME) WITH CHECK OPTION -- OK Of course, any code that decompiles into SQL will have to be careful to not produce unparseable SQL. Have a ncie day, -- Martijn van Oosterhout kleptog

Re: [HACKERS] LIKE, leading percent, bind parameters and indexes

2006-05-26 Thread Martijn van Oosterhout
. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [HACKERS] Creating a case insensitive data type

2006-05-26 Thread Martijn van Oosterhout
and using a new operator all over the place is not an option... How could I do this? Can I accomplish this via another method? Try this: http://gborg.postgresql.org/project/citext/projdisplay.php Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each

Re: [HACKERS] SSL certificate info on SQL level and HSM support for libpq

2006-05-22 Thread Martijn van Oosterhout
PostgreSQL function from another. It is clear enough from examples in the sources, but... Hmm, documentation patches welcome... Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability

Re: [HACKERS] Duplicate definition of LOCALEDIR

2006-05-22 Thread Martijn van Oosterhout
and $exp_localedir, which are not the same and pg_config.h gets one and pg_config_paths.h gets the other. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc

Re: Porting MSSQL to PGSQL (Was: [HACKERS] [OT] MySQL is bad, but THIS bad?)

2006-05-22 Thread Martijn van Oosterhout
, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [pgsql-advocacy] [HACKERS] [OT] MySQL is bad, but THIS bad?

2006-05-22 Thread Martijn van Oosterhout
pg_dump upgrades across versions. Anyway, it was just a thought and it didn't generate any comments at the time. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate

[HACKERS] Update on sort-compression stuff

2006-05-22 Thread Martijn van Oosterhout
to be beneficial. - Consider replacing pg_lzcompress with zlib if available. Or at least test pg_lzcompress in a more realistic environment, because it seems quite slow. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability

Re: [HACKERS] Compression and on-disk sorting

2006-05-21 Thread Martijn van Oosterhout
without compression. The compression has cut the I/O wait from 10sec to 1.5sec at the expense of 5.5sec of compression time. If you had a faster compression algorithm (zlib is not that fast) the results would be even better... Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http

Re: [HACKERS] [OT] MySQL is bad, but THIS bad?

2006-05-20 Thread Martijn van Oosterhout
van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [HACKERS] [OT] MySQL is bad, but THIS bad?

2006-05-20 Thread Martijn van Oosterhout
-contrib-8.1 Voila! Tsearch installed at your fingertips. What else were you expecting? Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital

Re: [HACKERS] SSL certificate info on SQL level and HSM support for libpq

2006-05-19 Thread Martijn van Oosterhout
? -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [HACKERS] Compression and on-disk sorting

2006-05-19 Thread Martijn van Oosterhout
On Fri, May 19, 2006 at 09:03:31AM -0400, Tom Lane wrote: Martijn van Oosterhout kleptog@svana.org writes: I'm seeing 250,000 blocks being cut down to 9,500 blocks. That's almost unbeleiveable. What's in the table? Yeah, I'd tend to question the test data being used. gzip does not do

Re: [HACKERS] [OT] MySQL is bad, but THIS bad?

2006-05-19 Thread Martijn van Oosterhout
than once I thought while waiting for stuff to compile: if I'd chosen mysql I'd be done by now... Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc

Re: [HACKERS] Compression and on-disk sorting

2006-05-19 Thread Martijn van Oosterhout
, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [HACKERS] String Similarity

2006-05-19 Thread Martijn van Oosterhout
in contrib. Whatever you come up with might fit in well there... Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [HACKERS] [OT] MySQL is bad, but THIS bad?

2006-05-19 Thread Martijn van Oosterhout
not the only one. OpenSSL is an optional part of most Linuxes, so there's no way you can use that exception. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc

Re: [HACKERS] Question about casts

2006-05-18 Thread Martijn van Oosterhout
time. Any user can add their own casts if they want, but the system generally only includes the ones useful to many people or those required for standards complience. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability

Re: [HACKERS] Compression and on-disk sorting

2006-05-18 Thread Martijn van Oosterhout
, and we assume a large sort with many tapes, you're going to blow all your work_mem on buffers. If using compression uses more memory so that you can't have as many tapes and thus need multiple passes, well, we need to test if this is still a win. Have a nice day, -- Martijn van Oosterhout

Re: [HACKERS] Compression and on-disk sorting

2006-05-17 Thread Martijn van Oosterhout
to arrange storage for this. I have some ideas though, but as Tom says, should go for the quick and dirty numbers first, to determine if it's even worth doing. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each

Re: [HACKERS] Compression and on-disk sorting

2006-05-17 Thread Martijn van Oosterhout
compress-whole-block and decompress-whole-block. zlib allows you to compress as the data comes along, keeping an eye on the output buffer while you do it. For an initial test, using zlib directly would probably be easier. If it works out we can look into alternatives. Have a nice day, -- Martijn van

Re: [HACKERS] Return results for PQexec vs PQexecP*

2006-05-17 Thread Martijn van Oosterhout
, if you want all the result sets, you need to be looking at PQsendquery and co. Have a ncie day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital

Re: [HACKERS] Compression and on-disk sorting

2006-05-17 Thread Martijn van Oosterhout
/temp/compress-sort.patch Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [HACKERS] [BUGS] BUG #2429: Explain does not report object's schema

2006-05-16 Thread Martijn van Oosterhout
a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [HACKERS] Creating a Pseudocolumn

2006-05-16 Thread Martijn van Oosterhout
. I'm assuming that what's actually being implemented is the SQL standard method with the Oracle alternative being another way of specifying the same thing? Have a ncie day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each

Re: [HACKERS] Wrong plan for simple join with index on FK

2006-05-16 Thread Martijn van Oosterhout
, or overestimating the cost of the hash join. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [HACKERS] [BUGS] BUG #2429: Explain does not report object's schema

2006-05-16 Thread Martijn van Oosterhout
should dramatically cut the overhead of EXPLAIN ANALYZE. Perhaps you could try that and report your experience. http://archives.postgresql.org/pgsql-patches/2006-05/msg00158.php BTW, just showing the plan takes no time at all, just use EXPLAIN without the ANALYZE. Have a nice day, -- Martijn van

Re: [HACKERS] Wrong plan for simple join with index on FK

2006-05-16 Thread Martijn van Oosterhout
, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [HACKERS] Compression and on-disk sorting

2006-05-16 Thread Martijn van Oosterhout
too hard, except the whole logtape process kinda gets in the way. If it wern't for the mark/restore it'd be trivial. Might take a stab at it some time, if I can think of a way to handle the seeking... -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according

Re: [HACKERS] Compression and on-disk sorting

2006-05-16 Thread Martijn van Oosterhout
it needs to support it there. It might be easier to switch to giving each tape it's own file... I don't think it would make much difference. OTOH, if this turns out to be a win, the tuplestore could have the same optimisation. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http

Re: [HACKERS] Creating a Pseudocolumn

2006-05-15 Thread Martijn van Oosterhout
look how that works. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [HACKERS] Creating a Pseudocolumn

2006-05-15 Thread Martijn van Oosterhout
On Mon, May 15, 2006 at 11:17:41AM -0400, Jonah H. Harris wrote: On 5/15/06, Martijn van Oosterhout kleptog@svana.org wrote: tableoid is a pseudo-column like you mean, perhaps you should look how that works. I thought tableoid was a system column with a physical representation on the tuple

Re: [HACKERS] Compression and on-disk sorting

2006-05-15 Thread Martijn van Oosterhout
(). We don't use it and many OSes don't support it, but it is there. The O/S is some overhead, but the benefits outweigh the costs IMHO. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability

<    5   6   7   8   9   10   11   12   13   14   >