Re: [HACKERS] [PATCHES] Fix for large file support (nonsegment mode support)

2008-03-19 Thread Martijn van Oosterhout
larger files and no-one else (not even a POSIX standard tar) can... Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description

Re: [HACKERS] Commit fest?

2008-03-15 Thread Martijn van Oosterhout
if you've fixed it but looking at the source it references an external JS file at http://js-kit.com/comments.js, maybe some security thing? It appears to work by fetch automatically generated JS files from the server to execute. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http

Re: [HACKERS] [NOVICE] encoding problems

2008-03-12 Thread Martijn van Oosterhout
tabs as is. The other alternative is to convert tabs to spaces on output. Can't remember why we didn't do that. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying

Re: [HACKERS] Lazy constraints / defaults

2008-03-10 Thread Martijn van Oosterhout
rewrite the whole table (to add new not null column). ISTM a while back someone adding a patch that made the above almost instantaneous. Probably remembering wrong though. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree

Re: [HACKERS] Maximum statistics target

2008-03-07 Thread Martijn van Oosterhout
the plans using it? I think Tom pointed there are a few places that are O(n^2) the number entries... Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn

Re: [HACKERS] Producer/Consumer Issues in the COPY across network

2008-02-28 Thread Martijn van Oosterhout
why I was wondering about the rows per packet. Sending bigger packets reduces overall overhead. (The malloc/free per row doesn't seem too efficient.) Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make

Re: [HACKERS] Two Coverity Scan volunteers needed

2008-02-27 Thread Martijn van Oosterhout
the developers could fix them. Looking at the latest results it has a lot of warnings about dead-code in libstemmer, which is not entirely surprising given that it's generated code. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful

Re: [HACKERS] Varlena Type Creation

2008-02-27 Thread Martijn van Oosterhout
characters signifying something? Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable. -- John F Kennedy signature.asc Description: Digital signature

Re: [HACKERS] code cleanup of timestamp code

2008-02-26 Thread Martijn van Oosterhout
64-integer support. Or at least, that's the theory. There was a question recently to check if there really are such systems still running... Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent

Re: [HACKERS] Producer/Consumer Issues in the COPY across network

2008-02-26 Thread Martijn van Oosterhout
per row) and libpq (which is one call per row)? It seems possible for us to request a number of rows from the server up to a preferred total transfer size. AIUI the server merely streams the rows to you, the client doesn't get to say how many :) Have a nice day, -- Martijn van Oosterhout [EMAIL

Re: [HACKERS] Including PL/PgSQL by default

2008-02-22 Thread Martijn van Oosterhout
van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable. -- John F Kennedy ---(end of broadcast)--- TIP 4: Have you searched our list archives

Re: [HACKERS] Timezone view

2008-02-21 Thread Martijn van Oosterhout
are the actual Olsen defined timezones, the rest are aliases. The zone.tab doesn't have all the zones. Try: find /usr/share/zoneinfo/ -name posix -prune -o -name right -prune -o -type f |wc -l Gives 577 on my system. Not sure if the zone.tab is even used. Have a nice day, -- Martijn van

Re: [HACKERS] wishlist for 8.4

2008-02-14 Thread Martijn van Oosterhout
-time, not compile time. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable. -- John F Kennedy signature.asc Description: Digital signature

Re: [HACKERS] Patch review

2008-02-12 Thread Martijn van Oosterhout
stable URLs for every email message? Is there software I can install on my server to do this? debbugs? *duck* Personally I like trac for its simplicity. You can add comments and post patches and track status. Which seems more than enough for what we do. Have a nice day, -- Martijn van Oosterhout

Re: [HACKERS] configurability of OOM killer

2008-02-08 Thread Martijn van Oosterhout
a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable. -- John F Kennedy signature.asc Description: Digital signature

Re: [HACKERS] configurability of OOM killer

2008-02-07 Thread Martijn van Oosterhout
along the normal setting. Shared memory segments can't be resized... There's not even a kernel API to do it. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable

Re: [HACKERS] Merge condition in postgresql

2008-02-04 Thread Martijn van Oosterhout
the standard definition then. The statement shouldn't be able to to see the effects of itself... Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable. -- John F Kennedy

Re: [HACKERS] configurability of OOM killer

2008-02-03 Thread Martijn van Oosterhout
on the fact that 99% of the time, that space isn't written to. Overcommit is precisely what makes forking as cheap as threads. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable

Re: [HACKERS] Limit changes query plan

2008-02-01 Thread Martijn van Oosterhout
a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable. -- John F Kennedy signature.asc Description: Digital signature

Re: [HACKERS] Will PostgreSQL get ported to CUDA?

2008-01-31 Thread Martijn van Oosterhout
to lookup the collation tables as often. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable. -- John F Kennedy signature.asc Description: Digital signature

Re: [HACKERS] what is suffix _P in gram.y

2008-01-27 Thread Martijn van Oosterhout
common to suffix it with a _P (the P stands for something but I forget what. Predicate?). That way you don't run into unexpected surprises when it compiles with other headers... Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful

Re: [HACKERS] Truncate Triggers

2008-01-26 Thread Martijn van Oosterhout
representing a tuplestore. How that would work for BEFORE STATEMENT triggers I don't know. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable. -- John F Kennedy

Re: [HACKERS] Thick indexes - a look at count(1) query

2008-01-23 Thread Martijn van Oosterhout
this overhead? \timing iirc. Inside psql, check the help. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable. -- John F Kennedy signature.asc Description

Re: [HACKERS] [GENERAL] SHA1 on postgres 8.3

2008-01-20 Thread Martijn van Oosterhout
. It's also interesting to note that the implementation in the backed is commented with: I do not expect this file to be used for general purpose MD5'ing of large amounts of data, only for generating hashed passwords from limited input. Have a nice day, -- Martijn van Oosterhout [EMAIL

Re: [HACKERS] SSL over Unix-domain sockets

2008-01-15 Thread Martijn van Oosterhout
are connected to, not opened. Trying to open it normally produces the error: No such device or address. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable. -- John F Kennedy

Re: [HACKERS] Postgresql Materialized views

2008-01-14 Thread Martijn van Oosterhout
a completely orthoginal problem. Someone needs to write the code to maintain such a view before you can even think about working on the planner. However, step 1 would be to get them onto the TODO list. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog

Re: [HACKERS] Proposal - libpq Type System beta-0.8a (was PGparam)

2008-01-09 Thread Martijn van Oosterhout
a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable. -- John F Kennedy signature.asc Description: Digital signature

Re: [HACKERS] SSL over Unix-domain sockets

2008-01-04 Thread Martijn van Oosterhout
to check the data it's sending. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable. -- John F Kennedy signature.asc Description: Digital signature

Re: [HACKERS] Index Page Split logging

2008-01-02 Thread Martijn van Oosterhout
through the index, which can only be done by calling user-defined functions. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable. -- John F Kennedy signature.asc

Re: [HACKERS] Index Page Split logging

2008-01-02 Thread Martijn van Oosterhout
On Wed, Jan 02, 2008 at 04:04:48PM +0530, Gokulakannan Somasundaram wrote: On Jan 2, 2008 3:35 PM, Martijn van Oosterhout [EMAIL PROTECTED] wrote: If the goal is to only store the insert, then we need to determine during recovery which page the record needs to be added to. To do this you

Re: [HACKERS] Index Page Split logging

2008-01-02 Thread Martijn van Oosterhout
both? gist-btree is a nice example but IIRC it takes more diskspace and can't handle uniqueness. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable. -- John F Kennedy

Re: [HACKERS] Index Page Split logging

2008-01-02 Thread Martijn van Oosterhout
is a single operation), so I don't think you can actually combine the current split algorithm with the logging operation I suggest above. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution

Re: [HACKERS] Index Page Split logging

2008-01-01 Thread Martijn van Oosterhout
the relevent inforation to make this efficient. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable. -- John F Kennedy signature.asc Description: Digital signature

Re: [HACKERS] Spoofing as the postmaster

2007-12-29 Thread Martijn van Oosterhout
solution. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable. -- John F Kennedy signature.asc Description: Digital signature

Re: [HACKERS] Spoofing as the postmaster

2007-12-23 Thread Martijn van Oosterhout
by postgres can create a socket in that directory, any client attempting to connect to a server using that directory knows it's connecting to a server owned by 'postgres'. I can't think of any non-libpq clients which support Unix domain sockets? Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED

Re: [HACKERS] Spoofing as the postmaster

2007-12-23 Thread Martijn van Oosterhout
for such restrictions. Nothing is being prevented here. Things are being made possible that are otherwise difficult. Have a niec day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable. -- John F

Re: [HACKERS] Spoofing as the postmaster

2007-12-23 Thread Martijn van Oosterhout
the cluster after creating it --start-conf auto|manual|disabled Set automatic startup behaviour in start.conf (default: 'auto') Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make

Re: [HACKERS] binary decode

2007-12-22 Thread Martijn van Oosterhout
and creates an ascii dump (similar to pgdump). Yes, I wrote a program called pgfsck years ago which did this. Not for all data types, but most of the common ones. I'm in the process up upgrading it work with the latest versions. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED

Re: [HACKERS] pgwin32_open returning EINVAL

2007-12-20 Thread Martijn van Oosterhout
? Hmm, from a translation point of view wouldn't it be better to have the word violation inside each of the _(), since not all languages might allow such substitions (gender problems). Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make

Re: [HACKERS] Sorting Improvements for 8.4

2007-12-20 Thread Martijn van Oosterhout
this is a NUMA architecture, but that's a whole other ball of wax. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable. -- John F Kennedy signature.asc Description

Re: [HACKERS] pgsql: Improve wording.

2007-12-18 Thread Martijn van Oosterhout
On Tue, Dec 18, 2007 at 09:32:51AM -0300, Alvaro Herrera wrote: Martijn van Oosterhout wrote: On Mon, Dec 17, 2007 at 01:48:31PM +, Alvaro Herrera wrote: Log Message: --- Improve wording. I agree that the parenthised phrase should be removed. http

Re: [HACKERS] VACUUM ANALYZE out of memory

2007-12-11 Thread Martijn van Oosterhout
with 128 MB before I leave in the evening, though (assuming the other tests I'm running complete by then). What you want is a reasonable shared mem, maybe 0.5GB and a smaller maintainence workmem since the letter is probably what's killing you. Have a nice day, -- Martijn van Oosterhout [EMAIL

Re: [HACKERS] VACUUM ANALYZE out of memory

2007-12-11 Thread Martijn van Oosterhout
, I'd say you're better off using the smaller amount so you can have higher maintainence work mem. VACUUM doesn't benefit much from lots of shared buffers, but it does benefit from maint workmem. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who

Re: [HACKERS] pg_dump and BINARY mode COPY

2007-12-06 Thread Martijn van Oosterhout
guessing... Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable. -- John F Kennedy signature.asc Description: Digital signature

Re: [HACKERS] [GENERAL] Empty arrays with ARRAY[]

2007-11-29 Thread Martijn van Oosterhout
the type anymore. Hope this helps, Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable. -- John F Kennedy signature.asc Description: Digital signature

Re: [HACKERS] pgwin32_open returning EINVAL

2007-11-28 Thread Martijn van Oosterhout
be more user-friendly if the message was displayed (just as for unix) rather than the code. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable. -- John F Kennedy

Re: [HACKERS] String encoding during connection handshake

2007-11-28 Thread Martijn van Oosterhout
it was added. It not usually a big deal because people set their own passwords... Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable. -- John F Kennedy signature.asc

Re: [HACKERS] String encoding during connection handshake

2007-11-28 Thread Martijn van Oosterhout
complaince requires this). This has nothing to do with C by the way. C has many features that allow you to work with different encodings. It just doesn't force you to use any particular one. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make

Re: [HACKERS] String encoding during connection handshake

2007-11-27 Thread Martijn van Oosterhout
is also wrong, because the matching is done at the byte level. So I suppose the answer is: whatever encoding you would like it to be/what the DB admin uses. This is all AIUI, Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful

Re: [HACKERS] Spinlock backoff algorithm

2007-11-16 Thread Martijn van Oosterhout
. http://gcc.gnu.org/ml/gcc-patches/2005-12/msg01518.html Hope this helps, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable. -- John F Kennedy signature.asc Description: Digital

Re: [HACKERS] psql -f doesn't complain about directories

2007-11-14 Thread Martijn van Oosterhout
think that psql shouldn't be ignoring the EISDIR error the kernel is returning. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable. -- John F Kennedy signature.asc

Re: [HACKERS] psql -f doesn't complain about directories

2007-11-14 Thread Martijn van Oosterhout
day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable. -- John F Kennedy signature.asc Description: Digital signature

Re: [HACKERS] psql -f doesn't complain about directories

2007-11-14 Thread Martijn van Oosterhout
On Wed, Nov 14, 2007 at 10:25:23PM +0100, Peter Eisentraut wrote: Martijn van Oosterhout wrote: To be honest I think that psql shouldn't be ignoring the EISDIR error the kernel is returning. We use fopen(), which doesn't appear to pass that on. It's not the fopen that fails, it's

Re: [HACKERS] Windows psql -f load of files with tabs changing to escape sequences

2007-11-13 Thread Martijn van Oosterhout
. What kind of problems? The encoding is done by psql, just before display. They're not stored like that in the DB. Can you be more specific as to the problems? Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution

Re: [HACKERS] Simplifying Text Search

2007-11-12 Thread Martijn van Oosterhout
'); Can't you do this with an SQL function that gets expanded inline? Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable. -- John F Kennedy signature.asc Description

Re: [HACKERS] Simplifying Text Search

2007-11-12 Thread Martijn van Oosterhout
is mashed into an operator at parse time, so yes, if you create the operator with the right name it will just work. Or not (I havn't tested it). Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent

Re: [HACKERS] [hibernate-team] PostgreSQLDialect

2007-11-11 Thread Martijn van Oosterhout
else? Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable. -- John F Kennedy signature.asc Description: Digital signature

Re: [HACKERS] Fwd: Clarification about HOT

2007-11-05 Thread Martijn van Oosterhout
. Or am I missing something? Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable. -- John F Kennedy signature.asc Description: Digital signature

Re: [HACKERS] Clarification about HOT

2007-11-02 Thread Martijn van Oosterhout
then it gets very expensive. Not to mention the locking considerations. Better keep it simple. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent revolution inevitable. -- John F Kennedy

Re: [HACKERS] Clarification about HOT

2007-11-02 Thread Martijn van Oosterhout
to lock all the pages to make sure the change is atomic... As soon as you have to lock more than one page, deadlocks become a problem. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Those who make peaceful revolution impossible will make violent

Re: [HACKERS] Proposal: Select ... AS OF Savepoint

2007-11-02 Thread Martijn van Oosterhout
feature under the umbrella of postgres. I'm still confused. Why on earth would you want to run a query against an old snapshot? If you want a stable view, I'd think of opening a cursor or using a temporary table. And where does serializable come into this? Have a nice day, -- Martijn van

Re: [HACKERS] Multiple trees in parsetree_list

2007-10-30 Thread Martijn van Oosterhout
from the parser/gram.c? AIUI, if there are RULEs on a table, you can get multiple queries as the result of a single request. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ From each according to his ability. To each according to his ability

Re: [HACKERS] module archive

2007-10-26 Thread Martijn van Oosterhout
be if the installed modules could be recognised as a block (using pg_depends) so that: 1. pg_dump can see them and emit only INSTALL module 2. Uninstall removes everything that was installed This only covers installtion though, not building or compiling. Have a nice day, -- Martijn van Oosterhout

Re: [HACKERS] PostGreSQL and zlib

2007-10-25 Thread Martijn van Oosterhout
On Thu, Oct 25, 2007 at 01:49:57PM +0200, Hubert FONGARNAND wrote: Another question : does this TOAST code works for all type of data, like TEXT (in our case) Yes. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ From each according to his ability

Re: [HACKERS] Opportunity for a Radical Changes in Database Software

2007-10-25 Thread Martijn van Oosterhout
relibility becomes the real issue though, you can always produce the wrong answer instantly, the trick is to get the right one... Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate

Re: [HACKERS] Feature Freeze date for 8.4

2007-10-24 Thread Martijn van Oosterhout
the bitrot? Just doing a CVS update will probably just mark everything conflicted, so I'm wondering is GIT can do it better. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ From each according to his ability. To each according to his ability

Re: [HACKERS] Feature Freeze date for 8.4

2007-10-23 Thread Martijn van Oosterhout
can fix the disparity I think most of the problems will go away... Ofcourse, posting just prior FF doesn't help, but I think that's a chicken/egg problem. People do what works. Have a ncie day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ From each according to his

Re: [HACKERS] Including Snapshot Info with Indexes

2007-10-20 Thread Martijn van Oosterhout
as in actual usage only the first is likely to generate a real I/O. If your problem is cache it seems to me you should test with a table larger than your shared buffers and perhaps even larger than your total memory, since this is the case we're actually interested in. Have a ncie day, -- Martijn van

Re: [HACKERS] debugger

2007-10-19 Thread Martijn van Oosterhout
to file index.c for example? Thank, Are you correctly attaching the debugger to the child (and not just the postmaster). Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate

Re: [HACKERS] Locales and Encodings

2007-10-12 Thread Martijn van Oosterhout
, rather than making more workarounds. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] 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] Locales and Encodings

2007-10-12 Thread Martijn van Oosterhout
, -- Martijn van Oosterhout [EMAIL PROTECTED] 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] Timezone database changes

2007-10-09 Thread Martijn van Oosterhout
. For both money and timestamps the taggedtypes module provides exactly what you want. It stores the timezone/currency as entered and displays that when output. Sometimes that's what you want, sometimes it's not. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org

Re: [HACKERS] mal advice in FAQ 4.1.

2007-10-09 Thread Martijn van Oosterhout
... The standard does have stuff relating to extracting samples from tables, but they're not implemented. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description

Re: [HACKERS] Change request ...

2007-09-27 Thread Martijn van Oosterhout
too often. It's been on the TODO list for at least 5 years... Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] 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] Change request ...

2007-09-27 Thread Martijn van Oosterhout
too, but it's a hack, it won't work in the general case. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] 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] Getting to 8.3 beta1

2007-09-27 Thread Martijn van Oosterhout
remember why). In any case, to add it now for linux would be a one-line change. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] 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] Getting to 8.3 beta1

2007-09-27 Thread Martijn van Oosterhout
On Thu, Sep 27, 2007 at 01:07:33PM -0400, Tom Lane wrote: Martijn van Oosterhout [EMAIL PROTECTED] writes: The original patch for controlling the export list on Linux included support for symbol versioning. Eventually a version of the export.list control was committed, but without

Re: [HACKERS] invalidly encoded strings

2007-09-11 Thread Martijn van Oosterhout
perl distinguish between encode which is text-bytea and decode which is bytea-text. We've got convert for oth and that causes problems. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ From each according to his ability. To each according to his ability

Re: [HACKERS] Hash index todo list item

2007-09-10 Thread Martijn van Oosterhout
not just going to happen a lot, it is going to be common, even for unique indexes. Presumably HOT will help with this, but that relies on all index columns not to change. The major benenfits will mostly come from not storing the key at all. I think. Have a nice day, -- Martijn van Oosterhout

Re: [HACKERS] invalidly encoded strings

2007-09-10 Thread Martijn van Oosterhout
. Is there a standard somewhere that maps integers to characters in EUC-JP. If so, how can I find out what character 512 is? Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate

Re: [HACKERS] invalidly encoded strings

2007-09-10 Thread Martijn van Oosterhout
to deal with this. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] 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] invalidly encoded strings

2007-09-09 Thread Martijn van Oosterhout
difference. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] 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] [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC)

2007-09-07 Thread Martijn van Oosterhout
. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] 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] Hash index todo list item

2007-09-07 Thread Martijn van Oosterhout
matching... (combined with other index, or even just the same index). Neat. Have a nice day, Martijn van Oosterhout [EMAIL PROTECTED] 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] text search vs schemas

2007-08-17 Thread Martijn van Oosterhout
, -- Martijn van Oosterhout [EMAIL PROTECTED] 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] text search vs schemas

2007-08-17 Thread Martijn van Oosterhout
On Fri, Aug 17, 2007 at 10:42:09AM -0400, Tom Lane wrote: Martijn van Oosterhout [EMAIL PROTECTED] writes: I'm unsure how it works now, but it seems reasonable that when a regclass/regtype/regetc is passed to a trigger, pass it in OID form. If you insist on a solution that involves

Re: [HACKERS] has anyone looked at burstsort ?

2007-07-14 Thread Martijn van Oosterhout
the current method is another question entirely. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] 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] Proposal: In-Place upgrade concept

2007-07-04 Thread Martijn van Oosterhout
easily, we just might have to have a backup method for the cases where the simple cases doesn't work... Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc

Re: [HACKERS] ACM Paper relevant to our buffer algorithm

2007-07-04 Thread Martijn van Oosterhout
everything ASAP. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] 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] Proposal: In-Place upgrade concept

2007-07-03 Thread Martijn van Oosterhout
so far is that we're intending to upgrade pages on the fly? Which means that at any point in time, some pages will be converted and some not, so the tuple descriptor isn't going to help, surely you need some identifier on the page telling you if it's upgraded or not? Have a nice day, -- Martijn van

Re: [HACKERS] Proposal: In-Place upgrade concept

2007-07-03 Thread Martijn van Oosterhout
(a REINDEX will upgrade every page in the table anyway...). I think it'd still be cheaper than dump/restore. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc

Re: [HACKERS] Proposal: In-Place upgrade concept

2007-07-03 Thread Martijn van Oosterhout
REINDEX will simply fix the problem outright. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] 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] GiST consistent function, expected arguments; multi-dimensional indexes

2007-07-02 Thread Martijn van Oosterhout
, -- Martijn van Oosterhout [EMAIL PROTECTED] 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] GiST consistent function, expected arguments; multi-dimensional indexes

2007-07-02 Thread Martijn van Oosterhout
. However, variable-length values are always byref. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] 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] Restartable signals 'n all that

2007-07-01 Thread Martijn van Oosterhout
to continue a sleep that has been interrupted by a signal more easily. But I don't know if that would help on your HPUX box though... Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ From each according to his ability. To each according to his ability

Re: [HACKERS] self defined data type with limit?

2007-06-27 Thread Martijn van Oosterhout
released version has it, but it will be in the next release. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] 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] GiST consistent function, expected arguments; multi-dimensional indexes

2007-06-27 Thread Martijn van Oosterhout
the queries, but it works with modifying any internal code at all... Given you can use rowtypes more easily these days, it's quite possible you use build an operator class on a row type... Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ From each according

Re: R: [postgresql-it] [HACKERS] no cascade triggers?

2007-06-27 Thread Martijn van Oosterhout
( article, supplier ); No trigger necessary... Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] 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] Selecting a constant question: A summary

2007-06-13 Thread Martijn van Oosterhout
contexts, and implicit casts handle any needed conversions. But now I understand why it does things this way. User-defined types makes for lots of interesting choices, but they are by far the most powerful feature of postgres and we don't want to mess with that. Have a nice day, -- Martijn van

Re: [HACKERS] Selecting a constant question

2007-06-12 Thread Martijn van Oosterhout
is basically won't fix from an optimisation point of view. Hope this clarifies things a bit, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

<    1   2   3   4   5   6   7   8   9   10   >