Re: [HACKERS] query cache

2012-03-25 Thread Billy Earney
Thanks.. I'll keep those issues in mind. On Sat, Mar 24, 2012 at 6:18 PM, Tatsuo Ishii wrote: > >> Well, you'd have to start by demonstrating the benefit of it. The > >> advantage of query caches in proxies and clients is well-known, because > you > >> can offload some of the work of the datab

Re: [HACKERS] query cache

2012-03-24 Thread Billy Earney
On Sat, Mar 24, 2012 at 3:22 PM, Joshua Berkus wrote: > Billy, > > > I've done a brief search of the postgresql mail archives, and I've > > noticed a few projects for adding query caches to postgresql, (for > > example, Masanori Yamazaki's query cache pro

Re: [HACKERS] query cache

2012-03-23 Thread Billy Earney
27;ve had many of these thoughts myself, and I guess it depends on the environment the database will be used, memory settings, and other variables, on how valuable a query cache would be. I'll definitely give this more thought before sending an official proposal. Billy

[HACKERS] query cache

2012-03-23 Thread Billy Earney
r the experts out there, does this seem reasonable, or am I misunderstanding the source code? Anyone aware of a project trying to accomplish this? Thanks! Billy Earney

Re: [HACKERS] Future of our regular expression code

2012-02-20 Thread Billy Earney
Tom, Thanks for your reply. So is the group leaning towards just maintaining the current regex code base, or looking into introducing a new library (RE2, PCRE, etc)? Or is this still open for discussion? Thanks! Billy On Mon, Feb 20, 2012 at 3:35 PM, Tom Lane wrote: > Billy Earney wri

Re: [HACKERS] Future of our regular expression code

2012-02-20 Thread Billy Earney
Jay, Good links, and I've also looked at a few others with benchmarks. I believe most of the benchmarks are done before PCRE implemented jit. I haven't found a benchmark with jit enabled, so I'm not sure if it will make a difference. Also I'm not sure how accurately the benchmarks will show how

Re: [HACKERS] Future of our regular expression code

2012-02-19 Thread Billy Earney
pcre library? It seems to have a lot of neat features, and also has a jit, and it looks like it is being actively maintained and has decent comments. On Sun, Feb 19, 2012 at 7:40 PM, Tom Lane wrote: > Billy Earney writes: > > I did a google search, and found the following: > > ht

Re: [HACKERS] Future of our regular expression code

2012-02-19 Thread Billy Earney
e. I didn't download and analyze their code, but maybe they have made some comments that could help, or maybe have some improvements to the code.. Just a thought.. :) Billy Earney On Sun, Feb 19, 2012 at 5:42 PM, Tom Lane wrote: > Brendan Jurd writes: > > Are you far enough into th

[HACKERS] a problem when poring from Oracle's PL/SQL to PLPGSQL

2008-06-13 Thread billy
open cursorSrc for queryStr; Here queryStr is a variable which type is TEXT OR VARCHAR or other string types. But in PLPGSQL, we can only open a cursor this way: open cursorSrc for select * from testtable; We cannot substitude "select * from testtable" with a variab

[HACKERS] why copy tuple in the end of trigger when nothing changed in NEW OLD record variable

2008-06-11 Thread billy
Trigger(s) */ { is FALSE for ever. I think we can add some judgment conditions in function plpgsql_exec_trigger() to avoid this problem.     billy [EMAIL PROTECTED]   2008-06-11 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscrip

Re: [HACKERS] why copy tuple in the end of trigger when nothing changed in NEW OLD record variable

2008-06-10 Thread billy
-10 23:43:00 In your letter you say:=== >"billy" <[EMAIL PROTECTED]> writes: >> I think we can add some judgment conditions in function >> plpgsql_exec_trigger() to avoid this problem. > >I don't especially see the point of adding extra comp

[HACKERS] why copy tuple in the end of trigger when nothing changed in NEW OLD record variable

2008-06-10 Thread billy
is FALSE for ever. I think we can add some judgment conditions in function plpgsql_exec_trigger() to avoid this problem.     billy [EMAIL PROTECTED]   2008-06-11 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscrip

Re: [HACKERS] Need Quote for 7.3

2002-11-27 Thread Billy O'Connor
> > > I think it's great - but don't quote me on that. :) > > > > > > > PostgreSQL. Because life's too short to learn Oracle. > > PostgreSQL. For those with more to do than babysit a database. > Ah, better. More orthogonal. ---(end of broadcast)-

Re: [HACKERS] Need Quote for 7.3

2002-11-26 Thread Billy O'Connor
can quote you! > > > I think it's great - but don't quote me on that. :) > PostgreSQL. Because life's too short to learn Oracle. :) Billy O'Connor ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [PORTS] [HACKERS] PostgreSQL supported platform report and a

2002-11-07 Thread Billy G. Allie
may not be necessary for it to occur on a particular platform. The patch to Makefile.global.in provides the means by which the individual ports can add the additional search paths. It's up to the port maintainers to decide if it's needed for their port, IMHO. -- | Billy G

Re: [HACKERS] PostgreSQL supported platform report and a patch.

2002-11-07 Thread Billy G. Allie
e executable(s) will have the runtime search paths in them so they will execute without having to change the default LD_LIBRARY_PATH setting. -- | Billy G. Allie| Domain: [EMAIL PROTECTED] | /| | 7436 Hartwell | MSN...: [EMAIL PROTECTED] |-/-|- | Dearborn, MI 48126| |/ |LLIE | (313) 582-1540| msg24907/pgp0.pgp Description: PGP signature

Re: [HACKERS] PostgreSQL supported platform report and a patch.

2002-11-07 Thread Billy G. Allie
was compiling using the native (UDK) compiler. and it failed in tuplesort.c. It was also unable to file the readline shared libraries without the changes to the makefiles or setting LD_RUN_PATH (which is a pain and is depreciated in OpenUNIX 8 and UnixWare 7). -- | Billy G. Allie

Re: [HACKERS] PostgreSQL supported platform report and a patch.

2002-11-07 Thread Billy G. Allie
). If I remove the inline from ApplySortFunction, it compiles and builds. In order for tuplesort.c to compile on OpenUNIX the code must be changed to either: 1. Remove the static modifier from myFuntionCall2 or 2. Remove the inline from ApplySortFunction or 3. Wrap the static mo

Re: [HACKERS] PostgreSQL supported platform report and a patch.

2002-11-07 Thread Billy G. Allie
Tom Lane wrote: > "Billy G. Allie" <[EMAIL PROTECTED]> writes: > > Here is the error messages generated during the compile: > > > cc -K pentium_pro,host,inline,loop_unroll -I../../../../src/include > > -I/usr/local/include -I/usr/local/ssl/include -c -o

Re: [HACKERS] PostgreSQL supported platform report and a patch.

2002-11-06 Thread Billy G. Allie
Tom Lane wrote: > "Billy G. Allie" <[EMAIL PROTECTED]> writes: > > Here is the error messages generated during the compile: > > > cc -K pentium_pro,host,inline,loop_unroll -I../../../../src/include > > -I/usr/local/include -I/usr/local/ssl/include -c -o

[HACKERS] PostgreSQL supported platform report and a patch.

2002-11-06 Thread Billy G. Allie
R_works = @ld_R_works@ + # Set trpath to a list of library paths included in LDFLAGS + # These paths can be added to rpath in the port specific makefiles if needed. + trpath = $(filter -L%,@LDFLAGS@) LDFLAGS = @LDFLAGS@ LDREL = -r LDOUT = -o | Billy G. Allie| Domain: [EM

Re: [HACKERS] Feature request: Truncate table

2002-06-12 Thread Billy O'Connor
rop create anyway? Is there some technical difference? -- Billy O'Connor ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] compiling pg 7.0.3 on sco 5.0.5

2000-12-03 Thread Billy G. Allie
If it compiles and passes regress tests that way, you're > better off without the #define anyhow. -- | Billy G. Allie| Domain: [EMAIL PROTECTED] | /| | 7436 Hartwell | Compuserve: 76337,2061 |-/-|- | Dearborn, MI 48126| MSN...: [EMAIL PROTECTED] |/ |LLIE | (313) 582-1540| PGP signature

[HACKERS] Re: [INTERFACES] Announcing PgSQL - a Python DB-API 2.0 compliant interface to PostgreSQL

2000-10-10 Thread Billy G. Allie
Tom Lane wrote: > "Billy G. Allie" <[EMAIL PROTECTED]> writes: > > Peter Eisentraut wrote: > >> Sounds interesting, but isn't "pgsql" an extremely unfortunate choice of > >> name, given that it's already used as an abbreviation for

[HACKERS] Re: [INTERFACES] Announcing PgSQL - a Python DB-API 2.0 compliant interface to PostgreSQL

2000-10-10 Thread Billy G. Allie
Peter Eisentraut wrote: > Billy G. Allie writes: > > > PgSQL v1.0 has been released. This is the first public release of PgSQL. > > It is available at http://sourceforge.net/projects/pgsql. > > Sounds interesting, but isn't "pgsql" an extremely unfort

[HACKERS] Patch to FAQ_SCO for PostgreSQL 7.1

2000-10-09 Thread Billy G. Allie
d them. You need to make the following changes to access the PostgreSQL man pages from UnixWare. | Billy G. Allie| Domain: [EMAIL PROTECTED] | /| | 7436 Hartwell | Compuserve: 76337,2061 |-/-|- | Dearborn, MI 48126| MSN...: [EMAIL PROTECTED] |/ |LLIE | (313) 582-1540| PGP signature

[HACKERS] Announcing PgSQL - a Python DB-API 2.0 compliant interface to PostgreSQL

2000-10-09 Thread Billy G. Allie
://www.python.org. -- | Billy G. Allie| Domain: [EMAIL PROTECTED] | /| | 7436 Hartwell | Compuserve: 76337,2061 |-/-|- | Dearborn, MI 48126| MSN...: [EMAIL PROTECTED] |/ |LLIE | (313) 582-1540| PGP signature