Re: [HACKERS] todo - I want the elog() thingy

2001-05-13 Thread james
function to unit test it, and send the patch when I'm done to the patches list. Any developers got some tips for me? --- James - Original Message - From: Oleg Bartunov [EMAIL PROTECTED] To: Bruce Momjian [EMAIL PROTECTED] Cc: PostgreSQL-development [EMAIL PROTECTED] Sent: Sunday, May 13, 2001

[HACKERS] swapcache-style cache?

2012-02-22 Thread james
swapcache seems to me remarkably elegant and, it would seem, very effective. James -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] json api WIP patch

2013-01-07 Thread james
The processing functions have been extended to provide populate_record() and populate_recordset() functions.The latter in particular could be useful in decomposing a piece of json representing an array of flat objects (a fairly common pattern) into a set of Postgres records in a single pass.

Re: [HACKERS] json api WIP patch

2013-01-08 Thread james
manipulations to one statement per table per logical operation even where there are multiple detail rows. Sometimes the network latency can be a pain too and that also suggests an RPC with unpack and insert locally. Cheers James -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] json api WIP patch

2013-01-08 Thread james
You can use COPY from a stored procedure, but only to and from files. I think that's in the chocolate fireguard realm though as far as efficiency for this sort of scenario goes, even if its handled by retaining an mmap'd file as workspace. If SPI provided a way to perform a copy to a

Re: [HACKERS] Strange Windows problem, lock_timeout test request

2013-01-26 Thread james
So, while no native 64-bit compilers are available for free as part of Visual Studio Express 2012 (11), it doesn't matter much. The issue is more that it's very much Microsoft's whim whether they release compilers at all and if so, which ones, when and how. I think I have a pretty vanilla

Re: [HACKERS] Visual Studio 2012 RC

2013-01-27 Thread james
Anyway, this is getting way off track. The point is that the MS SDKs and compilers are a bit of a mess and that MinGW support is useful because we can't rely on them continuing to offer free SDKs and compilers in future. Well, more compilers are always useful, but complaining that Microsoft

Re: [HACKERS] Visual Studio 2012 RC

2013-01-27 Thread james
On the contrary, only a few months ago there was a far from groundless fear that Microsoft would do just that. Following considerable outcry they changed their mind. But this is definitely not just paranoia. As for w64 support, the mingw-64 project exists more or less explicitly to produce 64

Re: [HACKERS] Have we out-grown Flex?

2012-05-03 Thread james
the parser drive a pull loop, or use a coroutine structure. Could go all trendy and use a PEG tool like, er,, peg (http://piumarta.com/software/peg/). (I haven't tried them tho') James -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

Re: [HACKERS] Have we out-grown Flex?

2012-05-03 Thread james
Doesn't that imply that a plan cache might be worthwhile? But no matter: didn't the OP really have issue with packaging and Windows support - and there are a lot of Windows users, and in general there are many Windows devs: making it easier for them to contribute has to be good doesn't it?

Re: [HACKERS] Have we out-grown Flex?

2012-05-03 Thread james
I believe there are tools that are significantly faster than flex. I believe re2c generates code that is faster. But the key thing is to test, probably, or perhaps ask around. I'm out of touch, but from memory flex wasn't the be-all and end-all. Lemon is definitely easy to maintain/port

Re: [HACKERS] Bugs in our Windows socket code

2012-05-13 Thread james
That is, if you request FD_WRITE events for a pre-existing socket with WSAEventSelect, you will not get one until the outbound network buffer has been filled and then has partially emptied. (This is incredibly broken, but Microsoft evidently has no intention of fixing it.) I think you should

[HACKERS] Fake async rep target

2012-05-29 Thread james
How easy would it be to implement a fake async rep target? Perhaps even as something that a server could allow a connection to request? (ie a suitably permissioned connection could convert itself to receive n async replication stream, rather than being statically configured?) I know that

Re: [HACKERS] Fake async rep target

2012-05-30 Thread james
the impacted tables and for each table a list of affected primary keys and whether they were inserted, deleted or updated. James -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Fake async rep target

2012-05-30 Thread james
the impacted tables and for each table a list of affected primary keys and whether they were inserted, deleted or updated. James -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Parallel Sort

2013-05-24 Thread james
Have you considered GPU-based sorting? I know there's been discussion in the past. If you use OpenCL, then you can use a CPU driver if there is no GPU, and that can allow you to leverage all the CPU cores without having to do the multi-thread stuff in the backend. While the compilation of

Re: [HACKERS] C++ compiler

2013-06-24 Thread james
On 25/06/2013 05:16, Tom Lane wrote: It might be time to reconsider whether we should move the baseline portability requirement up to C99. My understanding was that you picked up a lot of users when the Win32 port became useful. While you can build with msys, I would think that leaving

Re: [HACKERS] plpython implementation

2013-06-30 Thread james
On 01/07/2013 02:43, Claudio Freire wrote: In essence, you'd have to use another implementation. CPython guys have left it very clear they don't intend to fix that, as they don't consider it a bug. It's just how it is. Given how useful it is to have a scripting language that can be used outside

Re: [HACKERS] Improvement of checkpoint IO scheduler for stable transaction responses

2013-07-14 Thread james
On 14/07/2013 20:13, Greg Smith wrote: The most efficient way to write things out is to delay those writes as long as possible. That doesn't smell right to me. It might be that delaying allows more combining and allows the kernel to see more at once and optimise it, but I think the

Re: [HACKERS] [ANNOUNCE] IMCS: In Memory Columnar Store for PostgreSQL

2014-01-05 Thread james
On 05/01/2014 16:50, Robert Haas wrote: But on Windows, segments are*automatically* destroyed*by the operating system* when the last process unmaps them, so it's not quite so clear to me how we can allow it there. The main shared memory segment is no problem because the postmaster always has

Re: [HACKERS] [ANNOUNCE] IMCS: In Memory Columnar Store for PostgreSQL

2014-01-05 Thread james
On 05/01/2014 18:02, Robert Haas wrote: On Sun, Jan 5, 2014 at 12:34 PM, jamesja...@mansionfamily.plus.com wrote: On 05/01/2014 16:50, Robert Haas wrote: But on Windows, segments are*automatically* destroyed*by the operating system* when the last process unmaps them, so it's not quite so

Re: [HACKERS] [ANNOUNCE] IMCS: In Memory Columnar Store for PostgreSQL

2014-01-06 Thread james
On 06/01/2014 03:14, Robert Haas wrote: That's up to the application. After calling dsm_create(), you call dsm_segment_handle() to get the 32-bit integer handle for that segment. Then you have to get that to the other process(es) somehow. If you're trying to share a handle with a background

Re: [HACKERS] [ANNOUNCE] IMCS: In Memory Columnar Store for PostgreSQL

2014-01-06 Thread james
On 06/01/2014 04:20, Amit Kapila wrote: Duplicate handle should work, but we need to communicate the handle to other process using IPC. Only if the other process needs to use it. The IPC is not to transfer the handle to the other process, just to tell it which slot in its handle table

Re: [HACKERS] Securing make check (CVE-2014-0067)

2014-03-02 Thread james
On 02/03/2014 15:30, Magnus Hagander wrote: Terminal Services have definitely become more common over time, but with faster and cheaper virtualization, a lot of people have switched to that instead, which would remove the problem of course. I wonder how common it actually is, though, to

Re: [HACKERS] How to make ResourceOwnerForgetBuffer() O(1), instead of O(N^2) scale

2014-10-03 Thread james
On 03/10/2014 05:53, Kouhei Kaigai wrote: Yep, that's my pain. Even though usual query does not take many buffers pinned, my use case needs to fetch megabytes scale data at once because of performance reason; page-by-page synchronous scan makes GPU being idle. Doesn't your GPU have an async

Re: [HACKERS] WAL Re-Writes

2016-01-27 Thread james
On 27/01/2016 13:30, Amit Kapila wrote: Thoughts? Are the decreases observed with SSD as well as spinning rust? I might imagine that decreasing the wear would be advantageous, especially if the performance decrease is less with low read latency. -- Sent via pgsql-hackers mailing list

Re: [HACKERS] One process per session lack of sharing

2016-07-15 Thread james
On 15/07/2016 09:28, Craig Ringer wrote: I don't think anyone's considering moving from multi-processing to multi-threading in PostgreSQL. I really, really like the protection that the shared-nothing-by-default process model gives us, among other things. As I understand it, the main issue is

Re: [HACKERS] [GENERAL] Proposal for a cascaded master-slave replication system

2003-11-13 Thread James Robinson
butt on the line hosting our client's data. James Robinson Socialserve.com ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[HACKERS] Sponsoring enterprise features

2003-11-18 Thread James Rogers
doing this? Cheers, -James Rogers [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [HACKERS] Sponsoring enterprise features

2003-11-21 Thread James Rogers
, which I will post to the pg-hackers list. It is all stuff previously determined to be doable within the current PostgreSQL framework, and just requiring some work that my company is willing to help pay for. Cheers, -James Rogers [EMAIL PROTECTED] ---(end of broadcast

Re: [HACKERS] Tablespaces

2004-02-26 Thread James Rogers
performance by allocating most of the memory to the buffer cache rather than leaving it to the kernel file cache. I'm actually fairly curious to see what the new buffer management scheme will mean in terms of real world performance and parameter tuning. -James Rogers [EMAIL PROTECTED

Re: [HACKERS] user-defined default public acl

2004-04-20 Thread James Robinson
to solve at least the 'stay out of other user's crud by default' issues. James Robinson Socialserve.com ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [HACKERS] PostgreSQL pre-fork speedup

2004-05-06 Thread James Robinson
code ... James Robinson Socialserve.com ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list

Re: [HACKERS] PostgreSQL pre-fork speedup

2004-05-06 Thread James Robinson
() does a lot of little itty bitty writes to the frontend filedescriptor. What do you get if you comment out that block in child.c, around line 372? Either a faster system or a non-working one? James Robinson Socialserve.com ---(end of broadcast

Re: [HACKERS] PostgreSQL pre-fork speedup

2004-05-06 Thread James Robinson
the CompleteCommandResponse handler method ends with a call to pool_write_and_flush(), and you've pretty much gotta get a CompleteCommand message trailing all of those rows. James Robinson Socialserve.com ---(end of broadcast)--- TIP 1: subscribe

Re: [HACKERS] Weird prepared stmt behavior

2004-05-03 Thread James Robinson
to manipulate temporary tables. Quite spiffy, reducing the amount of surprise encountered by postgres neophytes. James Robinson Socialserve.com ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org

[HACKERS] Postgres Optimization: IO and Data Organization

2004-05-05 Thread James Thornton
I want to understand how Postgres organizes data and handles IO operations so that I will better know how to optimize a Postgres database server. I am looking for answers to specific questions and pointers to where this stuff is documented. How does Postgres organize its data? For example, is it

Re: [HACKERS] [GENERAL] Performance while loading data and indexing

2002-09-28 Thread James Maes
Has there been any thought of providing RAW disk support to bypass the fs? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bruce Momjian Sent: Thursday, September 26, 2002 3:57 PM To: Neil Conway Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread James Hubbard
at least doing they want. I've probably not said this before, but I appreciate all the hard work that everyone puts into this project. James Hubbard ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-29 Thread James Hubbard
these unscientific tests you're telling us about being so successful for some months? Vince. I open my mouth and insert foot: Where do I get any of these scientific tests to determine if the latest and greatest 7.3.x will not fall down on my favorite Unix? James Hubbard

Re: [HACKERS] PostgreSQL, NetBSD and NFS

2003-02-05 Thread James Hubbard
: http://kerneltrap.org/node.php?id=327 The actual link to the source http://www.freebsd.org/cgi/cvsweb.cgi/src/tools/regression/fsx/ James ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] FATAL 2: InitRelink(logfile 0 seg 173) failed: No such

2002-06-18 Thread James Thornton
Tom Lane wrote: That really should be impossible --- it says that a rename() failed for a file we just created. I judge from the spelling of the error message that you are running 7.1. 7.1.3 However, given that you state a system reboot is necessary and sufficient to make the problem go

Re: [HACKERS] FATAL 2: InitRelink(logfile 0 seg 173) failed: No such

2002-06-18 Thread James Thornton
Tom Lane wrote: James Thornton [EMAIL PROTECTED] writes: I am not running NFS on this system. Oh well, scratch that theory. Perhaps you should tell us what you *are* running --- what OS, what hardware? I still believe that this must be a system-level bug and not directly Postgres

[HACKERS] pg_restore: [archiver] input file does not appear to be a valid archive

2002-06-24 Thread James Thornton
I upgrade from PG 7.1.3 to 7.2, and I am trying to restore my dbs but I keep getting: [nsadmin@roam backup-20020622]$ pg_restore all-good.dmp pg_restore: [archiver] input file does not appear to be a valid archive ---(end of broadcast)--- TIP 2:

Re: [HACKERS] Democracy and organisation : let's make a revolution

2002-06-25 Thread James Hubbard
-to for using Open Office and unixODBC http://www.unixodbc.org/doc/OOoMySQL.pdf Others are considering MySQL. http://dba.openoffice.org/proposals/MySQL_OOo.html James Hubbard Dave Cramer wrote: IMO One of the big reasons that MySQL is viewed as being better is it's percieved simplicity. It has a large

[HACKERS] Postgres Bug Database

2002-07-09 Thread James Maes
Is there a bug tracking system someone online for the postgres engine? I was unable to locate one via the web site. Thanks, James ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[HACKERS] place for newbie postgresql hackers to work

2001-06-05 Thread James Buchanan
that the developers would actually like. I know this is a big ask, but once its done its done, and we can all get on with the job. Not trying to criticize anyone, this is not a flame! Just asking for a place for newbies to start hacking. :-) Appreciated very much. -- James

[HACKERS] Postgres is eating my CPU

2001-09-04 Thread James Thornton
PID PPID C STIME TTY TIME CMD postgres 1842 1 0 12:41 ?00:00:00 /usr/local/pgsql/bin/postmaster -B 6000 -o -S 2000 -S -D /usr/local/pgsql/data postgres 1872 1842 82 12:41 ?01:06:20 /usr/local/pgsql/bin/postgres localhost nsadmin james INSERT postgres 1997 1842

Re: [HACKERS] tablespaces and DB administration

2004-05-26 Thread James Robinson
step in this direction. James Robinson Socialserve.com ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] pg_dump --comment?

2004-05-28 Thread James Robinson
is flawed, then negative kudos to my puny mind. James Robinson Socialserve.com ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

Re: [HACKERS] Why frequently updated tables are an issue

2004-06-10 Thread James Robinson
On Jun 10, 2004, at 10:30 AM, [EMAIL PROTECTED] wrote: Prior to lazy vacuum, this was impossible. Do you know for sure that lazy vacuum and/or autovacuum does not indeed solve / alleviate the symptoms of the general problem of very high rate table updates? Back to lurking! James Robinson

Re: [HACKERS] bug in GUC

2004-06-24 Thread James Robinson
in the backend could be written , say, somewhere in the internals document around the coding conventions chapter: http://developer.postgresql.org/docs/postgres/source.html I myself don't have a clue, not being a backend hacker, so I'll just slink back to my cave. James Robinson Socialserve.com

Re: [HACKERS] User Quota Implementation

2004-07-09 Thread James Robinson
implementation? Quotas per user per tablespace, assuming 7.5 gets tablespaces. User quotas would make postgres on a shared university box much more pleasant. James Robinson Socialserve.com ---(end of broadcast)--- TIP 1: subscribe and unsubscribe

[HACKERS] Foreign keys locking

2004-08-05 Thread James Pharaoh
these instead of for update locks. How much work is involved in getting this done? Is interested in getting paid to undertake this? Please contact my email directly as I am not subscribed to this list. James Pharaoh ---(end of broadcast)--- TIP 1

Re: [HACKERS] Statement parsing problem ?

2004-09-15 Thread James Robinson
, t2, t3 cartesian product joined with t4. James Robinson Socialserve.com ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

[HACKERS] Thank you ...

2004-10-08 Thread James Robinson
LOG: database system is ready We were back online within minutes of the interruption w/o any data loss. So, I raise my glass to you! Thank you! James Robinson Socialserve.com ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] Postgres performs a Seq Scan instead of an Index Scan!

2004-10-26 Thread James Robinson
casts the literal int4 to an int8, making the int8 column index useable. James Robinson Socialserve.com ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL

[HACKERS] Backend 8.0.0B4 crash on SELECT ...

2004-11-05 Thread James Robinson
) unit_zipcode_fkey FOREIGN KEY (zipcode) REFERENCES zipcode(id) James Robinson Socialserve.com ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so

Re: [HACKERS] Backend 8.0.0B4 crash on SELECT ...

2004-11-05 Thread James Robinson
Patch applied, fixes beta4 for the query with our data. Many thanks again! James Robinson Socialserve.com ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[HACKERS] plpgsql on 8.0b4 bug?

2004-11-18 Thread James Robinson
of transaction block ERROR: current transaction is aborted, commands ignored until end of transaction block COMMIT Many thanks in advance, James pets.sql Description: Binary data James Robinson Socialserve.com ---(end of broadcast)--- TIP

Re: [HACKERS] plpgsql on 8.0b4 bug?

2004-11-18 Thread James Robinson
. James Robinson Socialserve.com ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Re: [HACKERS] plpgsql on 8.0b4 bug?

2004-11-18 Thread James Robinson
spellings of the keyword. This seems a bit ugly but I can't think of any really good objections. James Robinson Socialserve.com ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command

Re: [HACKERS] Encrypt data type LO

2004-11-24 Thread James Robinson
seemed to suit us just fine. James Robinson Socialserve.com ---(end of broadcast)--- TIP 8: explain analyze is your friend

[HACKERS]

2005-09-07 Thread James Robinson
fails as normal. James Robinson Socialserve.com ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[HACKERS] Help: 8.0.3 Vacuum of an empty table never completes ...

2005-11-28 Thread James Robinson
a higher value for work_mem (10240, up from default of 1024). But the hourly crons went great for the subsequent two days. maintenance_work_mem is still at the default of 16384. Many thanks in advance! James James Robinson Socialserve.com ---(end of broadcast

Re: [HACKERS] Help: 8.0.3 Vacuum of an empty table never completes ...

2005-11-28 Thread James Robinson
: postgres social [local] VACUUM waiting' 28861 -- production servicing backend, now back in idle state. [ not in tx idle by regular idle ]. On Nov 28, 2005, at 11:09 AM, Tom Lane wrote: James Robinson [EMAIL PROTECTED] writes: Comparing the logs further with when it did complete, it seems that one

Re: [HACKERS] Help: 8.0.3 Vacuum of an empty table never completes ...

2005-11-28 Thread James Robinson
0x08170de9 in PostmasterMain () #18 0x0813e5e5 in main () (gdb) quit James Robinson Socialserve.com ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Help: 8.0.3 Vacuum of an empty table never completes ...

2005-11-28 Thread James Robinson
to remote? James Robinson Socialserve.com ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [HACKERS] Help: 8.0.3 Vacuum of an empty table never completes ...

2005-11-28 Thread James Robinson
that additional buffering a damnable offense? James Robinson Socialserve.com ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Help: 8.0.3 Vacuum of an empty table never completes ...

2005-11-28 Thread James Robinson
On Nov 28, 2005, at 1:46 PM, Tom Lane wrote: James Robinson [EMAIL PROTECTED] writes: backtrace of the sshd doesn't look good: Stripped executable :-( ... you won't get much info there. What of the client at the far end of the ssh connection? You should probably assume that the blockage

Re: [HACKERS] Help: 8.0.3 Vacuum of an empty table never completes ...

2005-11-28 Thread James Robinson
-wise? James Robinson Socialserve.com ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list

Re: [HACKERS] Error handling in plperl and pltcl

2004-12-03 Thread James Robinson
savepoint handling and all. James Robinson Socialserve.com ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] qsort again (was Re: [PERFORM] Strange Create Index

2006-02-16 Thread Craig A. James
Markus Schaber wrote: Ron wrote: ...and of course if you know enough about the data to be sorted so as to constrain it appropriately, one should use a non comparison based O(N) sorting algorithm rather than any of the general comparison based O(NlgN) methods. Sounds interesting, could you

[HACKERS] Pl/Python -- current maintainer?

2006-02-24 Thread James Robinson
I'm interested in poking though and taking a shot at getting my feet wet with pl/python. I see the file is copyright Andrew Bosma -- is he still around perhance? Is anyone currently the 'owner' ? James Robinson Socialserve.com ---(end of broadcast

Re: [HACKERS] Pl/Python -- current maintainer?

2006-02-24 Thread James Robinson
see that plpython functions cannot be declared to return void. That can't be too tough to remedy. Implementing the DBI 2.0 API interface to SPI can wait another day. On Feb 24, 2006, at 11:08 PM, Joshua D. Drake wrote: James Robinson wrote: I'm interested in poking though and taking a shot

[HACKERS] PG Extensions: Must be statically linked?

2006-03-02 Thread Craig A. James
I'm creating user-defined server extensions, written in C per the manual 31.9. C-Language Functions. Everything works well, but only if I fully link the .so such that there are *no* unresolved external references at all. Not even the stuff in libstdc++.a can be left out. I've tried setting

Re: [HACKERS] PG Extensions: Must be statically linked?

2006-03-02 Thread Craig A. James
Tom Lane wrote: I'm creating user-defined server extensions, written in C per the manual 31.9. C-Language Functions. Everything works well, but only if I fully link the .so such that there are *no* unresolved external references at all. Not even the stuff in libstdc++.a can be left out. If

Re: [HACKERS] PG Extensions: Must be statically linked?

2006-03-03 Thread Craig A. James
Peter Eisentraut wrote: Unfortunately, we're also using a second library (OpenBabel) that is written in C++. A good portion of the code I've written is a wrapper layer that hides the C++ objects and presents a simple C wrapper that works for Postgres. I suggest if you want to get any concrete

[HACKERS] FROM ONLY limitation in RICs

2003-06-08 Thread James Pye
figured I'd see if this is specified in the spec, and hopefully induce a change if it isn't. Thanks for you time, James btw, I'm not on the list(yet, perhaps), so please CC me. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ

[HACKERS] persistant psql feature suggestion

2003-06-27 Thread James Pye
it, and exit when the results are cat'd from the fifo. Just wanted to make sure nothing similar enough was already in existence, and if anyone could easily implement this. If no one wants to, I suppose I'll look into doing it if it's worth doing. :) Cheers, James pgp0.pgp

[HACKERS] plpython

2003-09-04 Thread James Pye
will come as well. My version has a short ways to go before it is ready for usage, but if you want to see what I've done, just drop me an e-mail. Comments? Criticisms? Feature suggestions? Anyone else doing significant work on plpython? -James pgp0.pgp Description: PGP signature

[HACKERS] Index/Function organized table layout

2003-10-01 Thread James Rogers
optimization), but I thought I would check with the people currently hacking on the system first, to see if there was a showstopper or if someone is already working on this. Cheers, -James Rogers [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4

Re: [HACKERS] Index/Function organized table layout

2003-10-02 Thread James Rogers
of time-series data stored in a table, with each series keyed to another table. The the typical tuple distribution creates pathological behaviors when buffer space becomes tight. Cheers, -James Rogers [EMAIL PROTECTED] ---(end of broadcast)--- TIP

Re: [HACKERS] Index/Function organized table layout

2003-10-02 Thread James Rogers
. You could always markup the index that CLUSTER uses to keep track of good candidates (plus some additional structures), but the more I think about that, the more it looks like a nasty hack. Cheers, -James Rogers [EMAIL PROTECTED] ---(end of broadcast

Re: [HACKERS] Index/Function organized table layout

2003-10-04 Thread James Rogers
On 10/2/03 11:34 PM, Hannu Krosing [EMAIL PROTECTED] wrote: James Rogers kirjutas N, 02.10.2003 kell 23:44: Not exactly. What you are describing is more akin to partitioning or hash-organized tables i.e. sorting insert/update tuples to various pages according to some hash function. What I

[HACKERS] Uses for Index/Function organizing

2003-10-04 Thread James Rogers
tool in the tool belt. Cheers, -James Rogers [EMAIL PROTECTED] ---(end of broadcast)--- TIP 8: explain analyze is your friend

[HACKERS] Architecture Roadmap?

2003-10-06 Thread James Rogers
questions: 1) Does anyone object to me working on these two areas? 2) What version target should I realistically be shooting for? Cheers, -James Rogers [EMAIL PROTECTED] ---(end of broadcast)--- TIP 7: don't forget to increase your free space

[HACKERS] Hacking PostgreSQL to work in Mac OS X 10.3 (Panther 7B85)

2003-10-11 Thread James Wilson
{DarwinPortsDir}/dports/databases/postgresql/work/ .darwinports.postgresql.state Remove the following lines: target: com.apple.configure Try the build of postgresql again, DO NOT clean it, just try the install again. - Best of luck (was re: works for me.) --- James

Re: [HACKERS] Hacking PostgreSQL to work in Mac OS X 10.3 (Panther 7B85)

2003-10-14 Thread James Wilson
: _PQfreemem _PQresultErrorField _PQsetNoticeReceiver _last_path_separator I noticed it's not linking with the -undefined suppress flag which I've found it required when building 'bundles' for darwin. Cheers, On 12/10/2003, at 3:28 AM, Marko Karppinen wrote: James, we've spent some time lately

Re: [HACKERS] Database Kernels and O_DIRECT

2003-10-15 Thread James Rogers
, it is the difference between middling performance in the typical case and highly optimal in just about every case. A database kernel lets you use an operating system in the way it likes to be used rather than using an API that you just happen to support. Cheers, -James Rogers [EMAIL PROTECTED

Re: [HACKERS] Database Kernels and O_DIRECT

2003-10-15 Thread James Rogers
On 10/14/03 11:31 PM, James Rogers [EMAIL PROTECTED] wrote: There is some abstraction in Postgres and the database is well-written, but it isn't written in a manner that makes it easy to swap out operating system or API models. It is written to be portable at all levels. A database kernel

Re: [HACKERS] Hacking PostgreSQL to work in Mac OS X 10.3 (Panther 7B85)

2003-10-15 Thread James Wilson
-installed readline et.al. which are in /opt/local/lib and /opt/local/include Removing the old postgres libs would resolve this build issue, but makes it a bit painful for users upgrading from an existing installation. On 15/10/2003, at 4:03 AM, Tom Lane wrote: James Wilson [EMAIL PROTECTED] writes

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-24 Thread James Rogers
of this particular beast. Cheers, -James Rogers [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get

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

2006-06-23 Thread James Robinson
it in production for anything. 6 + 7 could possibly be done atop mysql using a 3-tier model. James Robinson Socialserve.com ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe

Re: [HACKERS] Mostly Harmless: Welcoming our C++ friends

2008-12-06 Thread James Mansion
things you can do in C, but most of them are things I'd rather not do anyway. Run such a build on the build farm each night, and it will be obvious as soon as C++-unfriendly code sneaks in. And who know, maybe eventually we could use C++ properly in the code. James -- Sent via pgsql-hackers

Re: [HACKERS] Python 3.1 support

2009-11-15 Thread James Pye
On Nov 15, 2009, at 6:37 AM, Peter Eisentraut wrote: but these two features don't excite me at all, hrm.. at all? I can see how function modules might look like a half-step backwards from function fragments at first, but the benefits of a *natural* initialization section (the module body)

Re: [HACKERS] Python 3.1 support

2009-11-18 Thread James Pye
On Nov 18, 2009, at 8:37 AM, Peter Eisentraut wrote: The question is whether it helps the user, not the implementer. Sure, but do you have a patch waiting to implement tracebacks? I'd argue the reason it's never been done is due to the way procedures are currently managed in PL/Python. And

Re: [HACKERS] Python 3.1 support

2009-11-18 Thread James Pye
On Nov 18, 2009, at 1:36 PM, James Pye wrote: At this point, I'm not going to try getting it into PG. (apparent futility and such) ugh, on second thought, I think I've written a bit too much code to stop now. I'm going to get plpython3 as far as I can and submit it to the next commitfest

Re: [HACKERS] Python 3.1 support

2009-11-19 Thread James Pye
On Nov 19, 2009, at 3:12 AM, Peter Eisentraut wrote: The other approach, which is what James Pye's new implementation proposes (as I understand it), is to convert PostgreSQL types into specially made Python objects, such as Postgres.types.record or Postgres.types.timestamp. Convert

Re: [HACKERS] Python 3.1 support

2009-11-19 Thread James Pye
On Nov 19, 2009, at 11:32 AM, Peter Eisentraut wrote: But you wouldn't, for example, get away with breaking SQL (or even improving it incompatibly) to facilitate a better elog. This doesn't fit the situation. I'm not breaking PL/Python. I'm trying to add PL/Python3. =) I think of a PL/Python

  1   2   3   4   >