Re: [GENERAL] Request for review of new redis-fdw module

Redis PUBLISH is now supported so you can send messages to subscribers on a channel. Leon On Wed, Jan 28, 2015 at 12:23 AM, Leon Dang wrote: > The code has been posted to https://github.com/nahanni/rw_redis_fdw > > Anyone interested can test it out or review it. > > cheers >

Re: [GENERAL] Request for review of new redis-fdw module

764774 ns/op INSERT: Redis FDW: 187788 ns/op TEMP TABLE: 106843 ns/op TABLE: 3093156 ns/op redis-fdw is currently unoptimized (no table option caching, etc) so there is room for improvement. But so far so good. Leon > I've implemented a completely new Redis FDW m

Re: [GENERAL] Request for review of new redis-fdw module

piry FROM rsessions r, u WHERE r.sessid = (SELECT u.sessid FROM u); If the user's session is still valid then a row will be returned (Redis automatically destroys the key on expiry). -- -- to reset the expiry timeout for the user -- UPDATE rsessions SET expiry = 40 WHERE sessid = $

Re: [GENERAL] Request for review of new redis-fdw module

The code has been posted to https://github.com/nahanni/rw_redis_fdw Anyone interested can test it out or review it. cheers Leon Leon Dang wrote on 01/24/2015 04:17 PM: Hi I've implemented a completely new Redis FDW module which has little to do with github.com/pg-redis-fdw/redi

[GENERAL] Request for review of new redis-fdw module

I know I haven't implemented properly so assistance with that is also appreciated. Please email me if you can assist with reviewing. thanks Leon

Re: [GENERAL] Call procedure from a Job, Test a Job in pgAdmin?

TURN; END; $BODY$ LANGUAGE plpgsql Thank you for your consideration, Leon From: David Johnston [mailto:pol...@yahoo.com] Sent: Tuesday, June 21, 2011 10:30 AM To: 'Leon Match'; pgsql-general@postgresql.org Subject: RE: [GENERAL] Call procedure from a Job, Test a Job in pgAdmin?

[GENERAL] Call procedure from a Job, Test a Job in pgAdmin?

(); SELECT requests_curr_req(); EXECUTE requests_curr_req(); EXECUTE PROCEDURE requests_curr_req(); but nothing worked!? Could you please advise the right way to do that? Also, what would be the way to test in pgAdmin, if the Job is running at all? Thank you, Leon Match leon.ma

Re: [GENERAL] insert a SYSTIMESTAMP value in postgres

Thanks a lot for your help! The correct sentence to my solution is this: insert into request_queue (request_id, received_time ) values (new.request_id, LOCALTIMESTAMP ); Regards, Leon -Original Message- From: Osvaldo

[GENERAL] insert a SYSTIMESTAMP value in postgres

, SYSTIMESTAMP ); How can I insert a dynamic timestamp value in postgress, please? Thank you, Leon leon.ma...@convergia.net

[GENERAL] merge in postgres trigger function

known variable, Line 3: MERGE INTO Requests r" But "Requests" is a table is not a variable! What is wrong with my statement? May be Merge is not legal in postgres trigger functions? What would be the way around? Thank you, Leon leon.ma...@convergia.net

Re: [GENERAL] Foreign keys to inherited tables

Yeah I was thinking about a bunch of triggers too, but was wondering whether there were any other "elegant" solutions for this. The foreign keys are actually already guaranteed by my application logic, so I'm starting to wonder whether this is becoming more trouble to implement than

[GENERAL] Foreign keys to inherited tables

Hello, I was wondering, I'm reading that there is no support for foreign keys to inherited (child) tables -- are there any plans on supporting these in the (near) future, and/or are there any practical workarounds for this ? Regards, Leon Mergen -- Sent via pgsql-general mailing list (

Re: [GENERAL] Conditional JOINs ?

he child tables together this way. The EXPLAIN of this query: Append (cost=0.00..2169.52 rows=34376 width=94) -> Seq Scan ON child1 (cost=0.00..1824.71 rows=34371 width=94) -> Seq Scan ON child2 (cost=0.00..1.05 rows=5 width=56) Regards, Leon Mergen -- Sent via pgsql-gener

Re: [GENERAL] Conditional JOINs ?

On 3/19/08, Leon Mergen <[EMAIL PROTECTED]> wrote: > Excuse me for bumping this up again, but I still don't understand how > to use this approach to sequentially walk through all different child > tables in one select, without having to JOIN these tables all the time Ap

Re: [GENERAL] Conditional JOINs ?

will probably result in even worse performance, since the 'parent' table is huge). Am I misunderstanding something here, or is there simple no solution for what I want ? Regards, Leon Mergen -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Conditional JOINs ?

llow entries > with foo='some_type2', and both children have extra fields that > weren't present in the parent. Ah, silly that I failed to understand that. Thanks a lot for your response (Alban too) -- I can see table partitioning solving my problem. -- Leon Mergen http:/

Re: [GENERAL] Conditional JOINs ?

ve this problem, which can be my problem -- am I missing some technique how table partitioning can be used to extend a base table with several extra tables that provide extra information ? -- Leon Mergen http://www.solatis.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Conditional JOINs ?

t my database design is flawed) ? Regards, Leon Mergen -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Stripping apostrophes from data

27;t be an issue. > .. which is a good idea anyway when you're dealing with data which cannot easily be verified as 'safe' (such as text data) -- it's a great way to prevent all SQL injections, even when you're not expecting quotes. -- Leon Mergen http://www.solatis.com

[GENERAL] Unable to get postgres running after long time no vacuum

n single-user mode instead of the entire service. What I'm in now is some kind of loop of being unable to get postgres back up -- anyone has any idea what I can do to find out what the problem is, and what I can do to solve it ? Thanks in advance! Regards, Leon Mergen

[GENERAL] Unable to get postgres running after long time no vacuum

n single-user mode instead of the entire service. What I'm in now is some kind of loop of being unable to get postgres back up -- anyone has any idea what I can do to find out what the problem is, and what I can do to solve it ? Thanks in advance! Regards, Leon Mergen

[GENERAL] INSERT..RETURNING on a partitioned table

be supported in my use case. Any ideas/suggestions ? Thanks in advance! Regards, Leon Mergen ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] INSERT..RETURNING on a partitioned table

be supported in my use case. Any ideas/suggestions ? Thanks in advance! Regards, Leon Mergen ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

[GENERAL] hashtext () and collisions

sion happens between hashes ? I noticed that the function only returns a 32 bit number, so I figure it must be at least once in the 4 billion values. If this approach is not recommended (using hashes as keys), any other suggestions on how to make the subtable name derivable from an identificatio

[GENERAL] hashtext & collisions

sion happens between hashes ? I noticed that the function only returns a 32 bit number, so I figure it must be at least once in the 4 billion values. If this approach is not recommended (using hashes as keys), any other suggestions on how to make the subtable name derivable from an identificati

[GENERAL] hashtext () and collisions

sion happens between hashes ? I noticed that the function only returns a 32 bit number, so I figure it must be at least once in the 4 billion values. If this approach is not recommended (using hashes as keys), any other suggestions on how to make the subtable name derivable from an identificati

[GENERAL] hashtext () and collisions

sion happens between hashes ? I noticed that the function only returns a 32 bit number, so I figure it must be at least once in the 4 billion values. If this approach is not recommended (using hashes as keys), any other suggestions on how to make the subtable name derivable from an identificati

[GENERAL] INSERT..RETURNING on partitioned table

be supported in my use case. Any ideas/suggestions ? Thanks in advance! Regards, Leon Mergen ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] Mac OS X

?Have I addressed my question to the correct list?Nathan Nathan Leon Pace, MD, MStatUniversity of UtahSalt Lake City, UT 84132Office: 801.581.6393Fax: 801.581.4367Cell: 801.205.1019Pager: 801.291.9019Home: 801.467.2925

[GENERAL] Help from Havana

HelloI want to know how to print a database eschema with the information of tables, fields,keys,etc   Thanks   Giraldo How low will we go? Check out Yahoo! Messenger’s low PC-to-Phone call rates.

Re: [GENERAL] Database restoration performance issue on PostgreSQL 7.4.7

--- Tom Lane <[EMAIL PROTECTED]> wrote: > Leon Pu <[EMAIL PROTECTED]> writes: > > the database restoration on my PosgreSQL 7.4.7 Linux installation > is > > terribly poor. It takes more than one and half hour to restore a > 61M > > restored database. &g

[GENERAL] Database restoration performance issue on PostgreSQL 7.4.7

Is the problem related to my backup and restore command, or it's the problem of my system, or PostgreSQL installation? Best regards, Leon __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mai

Re: [GENERAL] PostgreSQL support on Redhat Advance Server 2.1

do you mean PostgreSQL 7.3 is supported by RedHat on Advanced Server 2.1? I only found PostgreSQL 7.1.3's rpms for RedHat Advanced Server 2.1, no newer version anymore. Anyway, since I cannot upgrade the operating system, could anybody give me recommendation for which PostgreSQL vers

Re: [GENERAL] PostgreSQL support on Redhat Advance Server 2.1

tween both PostgreSQL and RHEL side for PostgreSQL 8.x and RHEL 2.1, and I cannot upgrade the operating system. I think I have to use PostgreSQL 7.4.7. Best regards, Leon __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection a

Re: [GENERAL] PostgreSQL support on Redhat Advance Server 2.1

--- Devrim GUNDUZ <[EMAIL PROTECTED]> wrote: > Hi, > > On Fri, 2006-03-24 at 07:52 -0800, Leon Pu wrote: > > > I found the newest PostgreSQL binary download on Redhat Advance > Server > > 2.1 is version 7.4.7. > > > > > http://www.postgresql.o

[GENERAL] PostgreSQL support on Redhat Advance Server 2.1

8.0.4 or newer PostgreSQL? Best regards, Leon __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---(end of broadcast)--- TIP 9: In versions

[GENERAL] Delete with a multi-column join?

and a.cycleID = b.cycleID but that doesn't seem to be supported in postgres... Thanks in advance for you help! Leon ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[GENERAL] "Invalid message format" error from JDBC driver

Hello, all. I have a query that runs perfectly when I run it from pgAdmin3, but bombs when I run it from ColdFusion using the JDBC driver. I'm using postgres 7.4. The query uses dblink(), which I assume is the source of the problem. Can anyone provide me with any insight about why this would fa

[GENERAL] Change encoding of SQL_ASCII database with multibyte chars?

(possibly mangled) multi-byte characters back into their original form? Thanks for reading Leon ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Postgresql "FIFO" Tables, How-To ?

keeps track of wrap-around might be a good way to implement this in postgres. Sincerely, Leon Oosterwijk > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Dennis Gearon > Sent: Wednesday, July 16, 2003 1:14 PM > To: Jean-Luc Lachance

[GENERAL] Re: creating assertions in functions

hmm.. actually the problem i encountered didn't require me to try the impossible below! -leon Leon Sol Levy <[EMAIL PROTECTED]> wrote: : hi. i was wondering how to go about creating an assertion to be used within a : pl/sql function. : do i put : : create assertio

[GENERAL] creating assertions in functions

hi. i was wondering how to go about creating an assertion to be used within a pl/sql function. do i put create assertion check ... before or after "begin"? thanks -- -leon (in the dungeon of EUII @ UC Davis)

Re: [GENERAL] How to install patch.

ange into sources dir, issue 'make clean' (though that thing should be made even before patching), then ./configure , then make, and then you have a new and shining Postgres binaries! (don't forget to install 'em :) -- Leon. --- He knows he'll never have to answer for any of his theories actually being put to test. If they were, they would be contaminated by reality.

Re: [GENERAL] Re: [SQL] bad select performance fixed by forbidding hash joins

e of optimism in joins. But all that is quick and dirty hack. General way is hints, however. -- Leon. - "This may seem a bit weird, but that's okay, because it is weird." - Perl manpage.

Re: [GENERAL] OID IS INVALID?

y at once, because this means that surface got a scratch which grows larger every time the disc head moves over it. Trash your disc, and be happy again :) -- Leon. - "This may seem a bit weird, but that's okay, because it is weird." - Perl manpage.

[GENERAL] If frontend dies?

So here is the question: what do I do with such 'zombie' transactions? (The answer, I think , should have been in FAQ.) -- Leon.

Re: [GENERAL] Weird behavior of 'default user'

Leon wrote: > > Hello! > > Look at this: I, after a short investigation, I found that it is a BUG!!! Now I logged in as Postgres. Consider: --- adb=> select * from hh; dd |ff +-- leon| 5 le | 7 (2 rows) adb=> insert into hh (ff) values (9); INSERT 572224 1 a

[GENERAL] Weird behavior of 'default user'

Hello! Look at this: -- adb=> create table hh (dd char(2) default user, ff int4); CREATE adb=> insert into hh (ff) values (5); INSERT 572034 1 adb=> select * from hh; dd |ff ----+-- leon| 5 (1 row) -- How can I understand that? Column dd is of ty

Re[4]: [GENERAL] Joins and links

ows: we follow the link, > and if we find that in the tuple where we arrived this system field > is not NULL, we go to (the same table of course) where it is pointing > to. Sure VACUUM will eliminate these. Performance penalty is small. Best regards, Leon

Re[2]: [GENERAL] Joins and links

ave seen it can hardly choose the optimum way of performing a join. In pointer-field case optimizer can be quite dumb, because there is only one way to perform a query. Best regards, Leon

Re[2]: [GENERAL] Joins and links

t as request by Leon are impractical. D> It seems to me that record number relationships will fail completely if D> there can be more than one version of a record. Maybe it is a silly question, but what are "more than one version of a record"? In my opinion record is a atomic unique

Re[2]: [GENERAL] Joins and links

umber support as request by Leon are impractical. B> Yes, would be a big problem. Most commercial databases have found that B> the network data model is impractical in most cases. That's exacly why such powerful tool as SQL is incomparably slower than plain dbf in most cases. Ignoring n

Re[2]: [GENERAL] Joins and links

w. And, besides, it is not only my personal wish. What I am proposing is huge (dozen-fold) performance gain on widespread tasks. If you implement this, happy users will erect a gold monument to Postgres development team. Best regards, Leon

Re: [GENERAL] Fast join

mizer that qualification atable.afield>10 is very restrictive and should be treated on a par with "=" qualification. Such hint seems much easier to realize than to make optimizer gather real statistics on a table during decision process. -- Leon.

Re: [GENERAL] Fast join

g will require major rewrite of code. So there should at least be some way to give hints to optimizer, shouldn't it? -- Leon.